my apologies again. datatype was text in 7.4 and
varchar in 7.3... the database likely isn't the
cause, rather, my different datatypes is probably the
problem.
thanks for the help.
--- operationsengineer1@yahoo.com wrote:
> --- Michael Fuhr <mike@fuhr.org> wrote:
>
> > On Thu, Aug 11, 2005 at 11:50:02AM -0700,
> > operationsengineer1@yahoo.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
> >
>
> my apologies, i thought serial number was type text,
> but it is type varchar(). i will change it to text
> and see what happens.
>
> this is the error...
>
> Warning: pg_exec(): Query failed: ERROR: Cannot cast
> type character varying to integer in
> /home/home/adodb/drivers/adodb-postgres64.inc.php on
> line 741
> -1: ERROR: Cannot cast type character varying to
> integer
>
> it there is no error in 7.4.
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
