From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Jerome Lyles <susemail(at)hawaii(dot)rr(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Spacing in output |
Date: | 2004-09-14 23:35:07 |
Message-ID: | 20040914233507.GB23367@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Sep 14, 2004 at 01:21:48PM -1000, Jerome Lyles wrote:
> On Tuesday 14 September 2004 11:15 am, you wrote:
> > What is the field size of prod_name? You could use SUBSTR(prod_name,1,xx)
> > where xx is the max number of characters you want to see.
> >
> > Duane
> fieldsize: 255. I tried to use SUBSTR:
>
> sql_tutorial=> SUBSTR(prod_name,1,45; SELECT prod_name FROM Products;
> sql_tutorial(>
> sql_tutorial(>
> sql_tutorial(> SELECT prod_name FROM Products;
> sql_tutorial(> SUBSTR(prod_name,1,45;
>
> but I have the syntax wrong. What does '(>' instead of '=>' mean?
That means you havn't closed the opening bracket on the first line.
Every open bracket must be matched by a closing one...
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew T. O'Connor | 2004-09-15 00:01:13 | Re: Corrupted Data? |
Previous Message | Duane Lee - EGOVX | 2004-09-14 23:31:10 | Re: Spacing in output |