Re: column doesn't get calculated - updated

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: floyds(at)4peakstech(dot)com
Cc: "Pgsql-Sql" <pgsql-sql(at)postgresql(dot)org>, "Josh Wardle" <josh(at)truckmaster(dot)com>, "Gregory S(dot) Dodson" <greg(at)truckmaster(dot)com>
Subject: Re: column doesn't get calculated - updated
Date: 2003-07-20 04:42:17
Message-ID: 19897.1058676137@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-sql

<floyds(at)4peakstech(dot)com> writes:
> when i copy/paste the select stmt into psql, it works. or if i use it
> "dynamically". it doesn't work properly when i use it in a prepared
> statement -- which is what i am doing.

Could we see a self-contained example of the problem? It's hard to tell
whether you are dealing with a bug or pilot error ...

regards, tom lane

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2003-07-20 04:46:27 patch: clean up exception formatting
Previous Message Fernando Nasser 2003-07-19 15:03:54 Re: Prepared Statements

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-07-20 04:54:26 Re: Why do the two queries below return different results?
Previous Message Tom Lane 2003-07-20 04:40:22 Re: min() and NaN