Postgres Pro
Downloads
Home   >   mailing lists

Thread: unquoted special constants

unquoted special constants

From
"Christopher Kings-Lynne"
Date:
Hi,

Is this the complete list of constants that must not be quoted?

CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_DATE
LOCAL_TIME
LOCAL_TIMESTAMP
CURRENT_USER
SESSION_USER
USER

Anything else?  (Aside from functions?)

Chris

Re: unquoted special constants

From
Bruce Momjian
Date:
Looks like you got them all.  I assume you got those from gram.y.

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:
> Hi,
> 
> Is this the complete list of constants that must not be quoted?
> 
> CURRENT_TIME
> CURRENT_TIMESTAMP
> CURRENT_DATE
> LOCAL_TIME
> LOCAL_TIMESTAMP
> CURRENT_USER
> SESSION_USER
> USER
> 
> Anything else?  (Aside from functions?)
> 
> Chris
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073

Re: unquoted special constants

From
"Christopher Kings-Lynne"
Date:
No actually, the docs.

I need to know for the phpPgAdmin project...

Chris

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: Sunday, 26 January 2003 10:03 AM
> To: Christopher Kings-Lynne
> Cc: Hackers
> Subject: Re: [HACKERS] unquoted special constants
>
>
>
> Looks like you got them all.  I assume you got those from gram.y.
>
> ------------------------------------------------------------------
> ---------
>
> Christopher Kings-Lynne wrote:
> > Hi,
> >
> > Is this the complete list of constants that must not be quoted?
> >
> > CURRENT_TIME
> > CURRENT_TIMESTAMP
> > CURRENT_DATE
> > LOCAL_TIME
> > LOCAL_TIMESTAMP
> > CURRENT_USER
> > SESSION_USER
> > USER
> >
> > Anything else?  (Aside from functions?)
> >
> > Chris
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square,
> Pennsylvania 19073
>