Re: Cast Problem

On Thu, Aug 11, 2005 at 11:50:02AM -0700, operationsengineer1(at)yahoo(dot)com wrote:
> i do a sort by serial number. in order to sort the
> way i want, i need to cast serial_number (type text)
> as an integer.
>
> ... ORDER By serial_number::integer ASC;
>
> this works great in pgsql 7.4.x (whatever i'm using on
> my dev box, i think 7.4.3, but not sure), but it
> doesn't work in pgsql 7.3.9.
>
> it doesn't allow the query to complete and i
> eventually get a "non object" error.

What's the *exact* error message? I don't see "non object" anywhere
in the 7.3 source code. What client interface are you using?

The following example works for me in 7.3.10, and I don't see
anything in the Release Notes that suggests the behavior has changed
since 7.3.9:

CREATE TABLE foo (serial_number text);
INSERT INTO foo VALUES (1);
INSERT INTO foo VALUES (2);
INSERT INTO foo VALUES (3);
INSERT INTO foo VALUES (10);
INSERT INTO foo VALUES (20);
INSERT INTO foo VALUES (30);

SELECT * FROM foo ORDER BY serial_number::integer;
serial_number
---------------
1
2
3
10
20
30
(6 rows)

Maybe this example is too simple to show the problem. Could you
post a complete test case?

--
Michael Fuhr