Re: Boolean test - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Boolean test
Date
Msg-id Pine.LNX.4.30.0203150009030.970-100000@peter.localdomain
Whole thread Raw
In response to Boolean test  (Rudi Starcevic <rudi@oasis.net.au>)
List pgsql-sql
Rudi Starcevic writes:

> I can't see why my sql here is throwing an error,

(Next time it might be nice to show *what* error...)

>     SELECT    *
>     FROM    plan_template
>     WHERE    public = true;

"public" is a reserved word.  You need to double-quote it to be able to
use it.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-sql by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Boolean test
Next
From: "Enrico Mangano"
Date:
Subject: R: [GENERAL] UPDATE and SELECT result difference