On Thu, Sep 23, 1999 at 08:12:34PM -0600, Aaron J. Seigo wrote:
> hi..
>
[ Jim Richards <grumpy@cyber4.org> wrote: ]
> > How do I name a column in an SQL query. In Oracle I would use
> >
> > select now() 'the time now';
> >
> > how is this done in PostgreSQL?
> >
> if i understand your question:
>
> select now() as 'the time now';
Always test your code ;-)
idas_demo=> select now() as 'the time now';
ERROR: parser: parse error at or near "'"
idas_demo=> select now() as "the time now";
the time now
----------------------
1999-09-23 23:26:29-05
(1 row)
idas_demo=>
Hmm, seems since the string is a fieldname, it needs doublequotes.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005