Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> --- Jon Collette <[EMAIL PROTECTED]> wrote:
>> Thanks that was it exactly. I did notice another strange thing. When
>> using IS NULL in an plpgsql IF statement you have to use ISNULL. Same
>> with NOT NULL. Does this mean that ISNULL is more p
--- Jon Collette <[EMAIL PROTECTED]> wrote:
> Thanks that was it exactly. I did notice another strange thing. When
> using IS NULL in an plpgsql IF statement you have to use ISNULL. Same
> with NOT NULL. Does this mean that ISNULL is more proper than IS NULL?
Good question, I am not sure
--- Jon Collette <[EMAIL PROTECTED]> wrote:
> If a column with a boolean datatype doesn't have a default value. What
> type of value is set if nothing is inserted into that column? Here is
> my test table and the queries I have tried. I can't seem to be able to
> select the rows where happy
If a column with a boolean datatype doesn't have a default value. What
type of value is set if nothing is inserted into that column? Here is
my test table and the queries I have tried. I can't seem to be able to
select the rows where happy has no value.
Table "public.users"
Colum
