Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> You could do something like
> ... type boolean using case when field1=0 then false else true end;
Or you could save typing and just use "USING field1<>0"
Odd that everyone did a CASE for that.
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2005-08-30 13:50:11|
|Subject: Re: Intermittent stats test failures on buildfarm |
|Previous:||From: Jeff Trout||Date: 2005-08-30 12:28:18|
|Subject: Re: SHMMAX seems entirely broken in OS X 10.4.2 |
pgsql-sql by date
|Next:||From: Halley Pacheco de Oliveira||Date: 2005-08-30 13:43:33|
|Subject: Re: question|
|Previous:||From: Akshay Mathur||Date: 2005-08-30 13:11:14|
|Subject: Re: sql function: using set as argument|