Skip site navigation (1) Skip section navigation (2)

Re: date_part stored procs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tsoloane(at)mimecast(dot)co(dot)za
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: date_part stored procs
Date: 2004-03-26 23:03:13
Message-ID: 28231.1080342193@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
"Tsoloane Moahloli" <tsoloane(at)mimecast(dot)co(dot)za> writes:
>   SELECT INTO len * FROM (SELECT
> ((date_part(''year'',age(docDate))*12)+(date_part(''month'',age(docDate))))
> AS a;
 
> The problem is that it does not run and I cannot for the life of me tell
> why.    

I think you miscounted parentheses.

			regards, tom lane

In response to

Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2004-03-27 03:23:27
Subject: Re: autocommit
Previous:From: Bruno Wolff IIIDate: 2004-03-26 21:53:03
Subject: Re: order of results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group