On Wed, 14 Feb 2007, [EMAIL PROTECTED] wrote:
On Wed, 14 Feb 2007, Chris wrote:
semi-ambivalent wrote:
All,
I have a char(3) column that has occasional values of this:
(V)
In a PHP-called nested query I've a line something like:
select * from tableA where = any (select date from tableA where void !
= '(V)') group by date order by record
Shouldn't that be
select * from table where FIELD = any (.....)
?
--
Postgresql & php tutorials
http://www.designmagick.com/
Yes it should be, and I'm hoping I just made a typo in my post, but I've
missed bonehead mistakes like that in the past; it's not forbidden in the
future. I'll check after I take my son to school.
r
Well, I didn't forget a field (thank goodness), but I let a space creep in
in "!=", I had "! =". It was on a linewrap in a window but that's no
excuse to miss it. (sigh)
thx,
r
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
