Mark Roberts wrote:
>
> On Thu, 2008-07-17 at 12:16 -0400, Alvaro Herrera wrote:
> > Volkan YAZICI wrote:
> > > Hi,
> > >
> > > What's the difference between below two queue implementations?
> >
> > They are two different lock spaces. pg_advisory_lock does not conflict
> > with regular system l
On Thu, 2008-07-17 at 12:16 -0400, Alvaro Herrera wrote:
> Volkan YAZICI wrote:
> > Hi,
> >
> > What's the difference between below two queue implementations?
>
> They are two different lock spaces. pg_advisory_lock does not conflict
> with regular system locks, whereas LOCK TABLE does.
>
>
>
Still another way to do :-)
Thanks, Lennin.
Best,
Oliveiros
- Original Message -
From: "Lennin Caro" <[EMAIL PROTECTED]>
To: ; "A. Kretschmer"
<[EMAIL PROTECTED]>
Sent: Friday, July 18, 2008 3:04 PM
Subject: Re: [SQL] How to GROUP results BY month
i think this work
select id,cou
i think this work
select id,count from table group by to_char(date,'MM')
--- On Wed, 7/16/08, A. Kretschmer <[EMAIL PROTECTED]> wrote:
> From: A. Kretschmer <[EMAIL PROTECTED]>
> Subject: Re: [SQL] How to GROUP results BY month
> To: pgsql-sql@postgresql.org
> Date: Wednesday, July 16, 2008, 5:
