Re: date_part stored procs - Mailing list pgsql-sql

<table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td width="50%"><a
href="http://mail.mimecast.co.za/mcservices/mcinsert?code=31303037352c333537"><imgborder="0"
src="cid:[email protected]"/></a></td><td align="right" width="50%"><a
href="http://mail.mimecast.co.za/mcservices/mcinsert?code=31303037352c333538"><imgborder="0"
src="cid:[email protected]"/></a></td></tr></table><br /><br /> Perfect. Thanks a lot....<br
/><br/> -----Original Message-----<br /> From: [email protected]
[mailto:[email protected]]<br/> On Behalf Of Tom Lane<br /> Sent: 27 March 2004 01:03<br /> To:
[email protected]<br/> Cc: [email protected]<br /> Subject: Re: [SQL] date_part stored procs <br /><br
/><br/> "Tsoloane Moahloli" <[email protected]> writes:<br /> > SELECT INTO len * FROM (SELECT<br />
>((date_part(''year'',age(docDate))*12)+(date_part(''month'',age(docDat<br /> > e))))<br /> > AS a;<br /><br
/>> The problem is that it does not run and I cannot for the life of me tell<br /> > why. <br /><br /> I think
youmiscounted parentheses.<br /><br /> regards, tom lane<br /><br /> ---------------------------(end of
broadcast)---------------------------<br/> TIP 8: explain analyze is your friend<br /><br /><br /><br /><table
border="0"cellpadding="0" cellspacing="0" width="100%"><tr><td width="50%"><img border="0"
src="cid:[email protected]"/></td><td align="right" width="50%"><img border="0"
src="cid:[email protected]"/></td></tr></table><br /><p><font face="Arial"
size="1">Disclaimer</font><p><fontface="Arial" size="1">The information contained in this communication is 
andmay be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and
othersauthorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure,
copying,distribution or taking action in reliance of the contents of this information is strictly prohibited and may be
unlawful.Views and opinions are those of the sender unless clearly stated as being that of Mimecast (Pty) Ltd. Mimecast
(Pty)Ltd is neither liable for the proper, complete transmission of the information contained in this communication,
norany delay in its receipt or that the mail is virus-free. Mimecast (Pty) Ltd is not liable whatsoever for loss or
damageresulting from the opening of this message and/or attachments and/or the use of the information contained in this
messageand/or attachments.<br /></font>