error creating table for postgres

[Peter Haworth]

Watch out when using square brackets as sql delimiters - they're not
standard sql and will probably be rejected in some implementations.  Like
Ralph I always use delimiters around table/column names but stick with the
standard double quotes.

Pete
lcSQL Software <http://www.lcsql.com>


On Mon, Apr 22, 2013 at 11:37 AM, Ralph DiMola <rdimola at evergreeninfo.net>wrote:

> Dr,
>
> Of course brain moved slower than then the fingers. I miss-placed the
> bracket for the first field [uniq_sfky]. Should have been....
>
> CREATE TABLE [plumber_joe_the__001_sofa]  ([uniq_sfky] INTEGER PRIMARY KEY
> ,
> [subq] CHAR(3) , [a] TEXT, [b] TEXT, [c] TEXT, [d] TEXT, [ordr] INTEGER,
> [user] CHAR(20), [tstmp] TIMESTAMP WITH TIMEZONE )
>
>
> Ralph DiMola
> IT Director
> Evergreen Information Services
> rdimola at evergreeninfo.net
>
>
> -----Original Message-----
> From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On
> Behalf
> Of Dr. Hawkins
> Sent: Monday, April 22, 2013 1:55 PM
> To: How to use LiveCode
> Subject: Re: error creating table for postgres
>
> On Sun, Apr 21, 2013 at 9:50 PM, Ralph DiMola <rdimola at evergreeninfo.net>
> wrote:
> > I put brackets[] around table and field names to avoid this. I would
> > have written it like this. This convention also has the advantage of
> > being more readable.
> >
> > CREATE TABLE [plumber_joe_the__001_sofa]  (uniq_[sfky] INTEGER PRIMARY
> > KEY ,
>
> Ahh, readability . . . so usueful when we come back later.
>
> Of course, most of my queries get assembled over 2-5 lines of code, so . .
> .
> thanks
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>