bingo,
thaks
On Sat, 23 Sep 2000, Stephan Szabo wrote:
>
> I'd assume this would work:
> select * from table where booleanfield is null;
>
> Stephan Szabo
> [EMAIL PROTECTED]
>
> On Sat, 23 Sep 2000, Jeff MacDonald wrote:
>
> > how would i select all rows where a boolean value is neither
>
I'd assume this would work:
select * from table where booleanfield is null;
Stephan Szabo
[EMAIL PROTECTED]
On Sat, 23 Sep 2000, Jeff MacDonald wrote:
> how would i select all rows where a boolean value is neither
> t nor f.. ?
>
> ie if someone inserted without setting the boolean tag.
bignose=# create table test (
bignose(# val1int4,
bignose(# val2boolean);
CREATE
bignose=#
bignose=# insert into test (val1) values (56);
INSERT 322762 1
bignose=#
bignose=# select * from test;
val1 | val2
--+--
56 |
(1 row)
ta da :)
On Sat, 23 Sep 2000,
Hi,
AFAIK, you can't enter a null value in a bool field, it has to be 1 or 0.
\Indraneel
On Sat, 23 Sep 2000, Jeff MacDonald wrote:
> how would i select all rows where a boolean value is neither
> t nor f.. ?
>
> ie if someone inserted without setting the boolean tag.
>
> Jeff MacDonald,
>
how would i select all rows where a boolean value is neither
t nor f.. ?
ie if someone inserted without setting the boolean tag.
Jeff MacDonald,
-
PostgreSQL Inc | Hub.Org Networking Services
[EMAIL PROTECTED] | [EMAIL PROT
Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> By the way, is it normal that the "day" word doesn't appear in the interval?
> auction=# select interval(now()::abstime::int4);
> interval
>
> 30 years 9 mons 3 15:42:09
> (1 row)
Looks like a
On Thu, Sep 21, 2000 at 01:25:05PM -0700, Jie Liang wrote:
> Hi, there,
>
> urldb=# create table foo(sec int4);
> CREATE
> urldb=# insert into foo values(54321);
> INSERT 382942319 1
> urldb=# select interval(reltime (sec||'secs')) from foo;
> interval
> --
> 15:05:21
> (1 row)
By the
Paul Wehr <[EMAIL PROTECTED]> writes:
> create view complex_view as select blah, . , effective_date.date
> from tablea, tableb, tablec, effective_date
> where tablea.foo=tableb.foo
>
> and effective_date.date between tablec.start_date=tablec.end_date
> ;
> insert into effective_date
Summary: Proposed solution, and question on efficiency of technique
I don't know if this is what you are looking for, but I have a database where
I needed a relatively complex view (which I can do thanks to the expanded view
buffer in 7.0!, it didn't fit in 6.5.3), but I need to pass an "effecti
