Home > mailing lists

Re: select query of mysql to postgres - Mailing list pgsql-admin

From	David G. Johnston
Subject	Re: select query of mysql to postgres
Date	June 26, 2015 16:22:27
Msg-id	CAKFQuwZ5seDpe2hk_Pu-r1duaJ8VsU7fq2sU6zJybwX9b2Dk9Q@mail.gmail.com Whole thread Raw
In response to	Re: select query of mysql to postgres ("Burgholzer, Robert (DEQ)" <Robert.Burgholzer@deq.virginia.gov>)
List	pgsql-admin

Tree view

On Fri, Jun 26, 2015 at 7:58 AM, Burgholzer, Robert (DEQ) <Robert.Burgholzer@deq.virginia.gov> wrote:

So this seems to be saying that postgres does not have the ifnull function: http://www.postgresql.org/docs/9.2/static/functions-conditional.html http://www.postgresql.org/docs/9.2/static/functions-conditional.html

The function that performs equivalently is "COALESCE"

David J.

pgsql-admin by date:

From: Ankur Kaushik
Date: 26 June 2015, 15:27:43
Subject: Re: select query of mysql to postgres

From: sam turnbull
Date: 26 June 2015, 16:31:14
Subject: Restore backup of database to new database name

Re: select query of mysql to postgres - Mailing list pgsql-admin

Previous

Next