I think don't really unterstand your intend.
However there exists a type text in SQL and Postgres which is a text of
unspecified length and used like a SQL-String. Thus quoted with '
So when you earlier were able to gain the content of that field. It should
be no problem to quote it.
> -Origi
Title: RE: [SQL] pgmirror
Thanks for your response, however can you please translate, my Greek is not the best.
-Original Message-
From: Achilleus Mantzios [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 January 2005 6:57 PM
To: Theo Galanakis
Subject: Re: [SQL] pgmirror
O Theo Galan
create table xyz
(
field_foo char(1) check (field_foo in 'y', 'n'),
foo_detail varchar(255),
check (
case
when field_foo='y' and foo_detail is null
then false
else true
end
)
);
A simpler check would be :
CHECK(
(field_foo = 'y' AND foo_detail IS
Hi:
> > (A)
> > I have three radio boxes in the user form
> >
> > field_foo
> > []yes
> > []no
> > []unknown
> > ...
> > field_foo char(1) not null check
> > (field_foo in 'y', 'n', 'u')
> > OR
> > field_foo char(1) check (field_foo in 'y', 'n')
> >
> Option 1 - the
