Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

1) b 2) c 3) d 4) b & c -- Mailed by: UnReAl4U - unreal4u ICQ #: 54472056 www: http://www.chilehardware.com/

Re: [GENERAL] Recovery from another installation

postgres 2.5 ??? wow ... that's an old version... Consider an upgrade... >From what i know, it shouldn't be a problem, because it's primarily the same sub-version... It would be another story if it was from 2.5 to 2.6 (in that case, you should use pg_dump_all) ... But i really don't know if with a

Re: [GENERAL] bigint to ipaddress

There is no such thing as converting a bigint into an text ip address, unless you make it xD Google for "postgres INET_ATON" (INET_ATON is mysql's ip-to-int) However, there are datatypes in postgres which allow you to work directly with ips and networks: http://www.postgresql.org/docs/7.4/interact

[GENERAL] Select CASE when null ?

and other variations, however, I haven't be able to accomplish this, the idea is that it should always return at least 1 row... I know it must be a some kind of small stupidity, but after 2 hours googling and trying, i seriously thought of asking it to the list... Thanks in advance ;) Greetings,

[GENERAL] Select CASE when null ?

and other variations, however, I haven't be able to accomplish this, the idea is that it should always return at least 1 row... I know it must be a some kind of small stupidity, but after 2 hours googling and trying, i seriously thought of asking it to the list... Thanks in advance ;) Greetings,

Re: [GENERAL] Select CASE when null ?

On Wed, Jan 14, 2009 at 17:56, Mark Styles wrote: > > SELECT COALESCE(mid,0) AS mid, COALESCE(id_group,0) AS id_group > FROM users > WHERE username = 'test' > UNION > SELECT 0, 0 > WHERE NOT EXISTS (SELECT 1 FROM users WHERE username = 'test'); > > > -- > Mark > http://www.lambic.co.uk > > >