| From: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
|---|---|
| To: | "McCaffity, Ray (Contractor)" <McCaffityR(at)epg(dot)lewis(dot)army(dot)mil> |
| Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: newbie - syntax question |
| Date: | 2002-05-10 01:18:37 |
| Message-ID: | 3CDB1FED.99909B36@fourpalms.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
...
> > select distinct
> > uid = 'c' + trim(char(m.ctc_uid)),
> > command = e.msg_command,
> I think you probably want something like
> e.msg_command AS command,
and something like
('c' + trim(char(m.ctc_uid))) as uid,
which have forms more closely tied to SQL9x standards than your original
form.
While you are at it you might want to evaluate your needs for character
strings and choose the type (char, varchar, or text) which best matches
your application. You may be able to eliminate some of these
conversions.
- Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | R.Tichy | 2002-05-10 06:25:28 | [why copy ? its not correct working outside static sytax ? ] |
| Previous Message | Tom Lane | 2002-05-10 01:04:09 | Re: trouble with (lack of) indexing |