Re: left() in postgres

At 20:14 +0300 25/10/02, Peter Nixon wrote:
>I guess I don't understand how to use it properly. can anyone give me some
>more help. When I fire off the following query (at a database of radius
>records)
>
>SELECT substring('CalledStationId' from 2 for 3) FROM calls WHERE
>h323connecttime BETWEEN DATE'YESTERDAY' AND (DATE'YESTERDAY' + INTERVAL'1
>min');

Change this:

SELECT substring('CalledStationId' from 2 for 3)
^ ^

to this:

SELECT substring(CalledStationId from 2 for 3)

In the example you have given, CalledStationID is a literal instead
of a column.

The syntax for substr would be:

SELECT substr(CalledStationId', 2, 3)

Regards

Paul Miller
--
-
Carib Data Limited

<mailto:millerp(at)caribdata(dot)co(dot)uk>
<http://www.caribdata.co.uk>