Re: casting character varying to integer - order by numeric

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Bryce Nesbitt (mailing list account)" <bryce1(at)obviously(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: casting character varying to integer - order by numeric
Date: 2005-10-20 07:32:58
Message-ID: 4357482A.9050008@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Bryce Nesbitt (mailing list account) wrote:
> Tom Lane wrote:

>>As a general rule, you need to be more specific than that about which
>>version you are working with ;-)

> Oooh, I'd be so happy to. But I don't know. Yes, I don't know.
>
> I know which version of "psql" is installed on my local machine, but the actual
> database is remote. Is there a command to get the server version? As close as
> I can find is:
>
> stage=> \copyright

SELECT version();

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adriana Marcela Aguirre 2005-10-20 14:44:49 Sql - Error : Relation tmp_datos already exists
Previous Message Bryce Nesbitt (mailing list account) 2005-10-20 06:57:18 Re: casting character varying to integer - order by numeric