I have a column that is a varchar(6) I need to sort it by the rows that
are integers 1st then the character ones or vice versa, I just need the
values that can be converted to integer to sort by their numeric value.
i.e
1, 2, 3, 4, 5, 10, 11, A, B, C
instead of
1, 10, 11, 2, 3, 4, 5, A, B, C
Thanks,
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andreas
Kretschmer
Sent: Monday, January 08, 2007 11:19 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Sorting
Ragnar [EMAIL PROTECTED] schrieb:
test=*# select w, case when w ~
We are installing a new Postgresql server, it will not run
anything else but postgresql. We are currently looking at moving from a RHEL
4.0 system to FreeBSD.
Does one OS offer better performace over the other when
running postgresql?
Thanks,
Bart
Would anyone happen to have any examples or be able to point me to how to
write a stored procedure in C? Ive looked at
http://www.postgresql.org/docs/8.1/interactive/trigger-interface.html
But am still having problems with getting a compile to work on a Linux
machine. (linker options etc..)
Is there some kind of log, table or something that I could get more
information about a deadlock situation that is occurring in my database? I
just get a transaction number and a process id, which is useless to me
because my application terminates on any errors from the database? It occurs
On Thu, Sep 15, 2005 at 12:32:05PM -0500, Bart McFarling wrote:
Is there some kind of log, table or something that I could get more
information about a deadlock situation that is occurring in my database? I
just get a transaction number and a process id, which is useless to me
because my
postgres 7.4.2 on a RedHat Enterprise Server
using libpq on SCO Open Server
Seems that if a command takes too long I get ERROR:Canceling query due
to user request.
I have ulimit=unlimited
postgresql.conf has statement_timeout = 0
Any ideas on what could be causing this?
Thanks,
Bart
