Re: [GENERAL] isnull() function in pgAdmin3

On Mon, Oct 3, 2016 at 6:39 AM, dudedoe01 wrote: > What is the most feasible way to emulate the below MySQL function into > postgreSQL. Since the isnull() function is no longer supported in 9.6 > version. I have tried every trick in the hat to get the desired results. >

Re: [GENERAL] isnull() function in pgAdmin3

On 03/10/16 14:39, dudedoe01 wrote: What is the most feasible way to emulate the below MySQL function into postgreSQL. Since the isnull() function is no longer supported in 9.6 version. I have tried every trick in the hat to get the desired results. Still 'RPG INV' doesn't show only the other

Re: [GENERAL] isnull() function in pgAdmin3

On 10/03/2016 06:39 AM, dudedoe01 wrote: What is the most feasible way to emulate the below MySQL function into postgreSQL. Since the isnull() function is no longer supported in 9.6 One more time, Postgres does not have an isnull() function in any version AFAIK. You need to use IS NULL:

Re: [GENERAL] isnull() function in pgAdmin3

On Mon, Oct 3, 2016 at 6:39 AM, dudedoe01 wrote: > What is the most feasible way to emulate the below MySQL function into > postgreSQL. Since the isnull() function is no longer supported in 9.6 > version. I have tried every trick in the hat to get the desired results. >

Re: [GENERAL] isnull() function in pgAdmin3

What is the most feasible way to emulate the below MySQL function into postgreSQL. Since the isnull() function is no longer supported in 9.6 version. I have tried every trick in the hat to get the desired results. Still 'RPG INV' doesn't show only the other two then options show up. (case

Re: [GENERAL] isnull() function in pgAdmin3

On 09/30/2016 08:18 AM, dudedoe01 wrote: Select version(); shows postgreSQL 9.6beta3, compiled by Visual C++ build 1800, 64-bit There is no isnull() in 9.6 either, if that is what you are asking? Otherwise what is the question you want answered? -- Adrian Klaver adrian.kla...@aklaver.com

Re: [GENERAL] isnull() function in pgAdmin3

Select version(); shows postgreSQL 9.6beta3, compiled by Visual C++ build 1800, 64-bit -- View this message in context: http://postgresql.nabble.com/isnull-function-in-pgAdmin3-tp5923122p5923791.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via

Re: [GENERAL] isnull() function in pgAdmin3

On 09/28/2016 02:24 PM, dudedoe01 wrote: In future can you copy and paste the error. It makes it easier to deal with. Thanks. This is with the DATE data type. I have 9.5 version installed. The type really does not matter. The

Re: [GENERAL] isnull() function in pgAdmin3

This is with the DATE data type. I have 9.5 version installed. -- View this message in context: http://postgresql.nabble.com/isnull-function-in-pgAdmin3-tp5923122p5923277.html Sent from the PostgreSQL - general mailing list archive at

Re: [GENERAL] isnull() function in pgAdmin3

On Tue, Sep 27, 2016 at 3:12 PM, dudedoe01 wrote: > The tables I migrated from MySQL into postgreSQL have exactly the same amount > of rows of data so the problem is inside the view being created. Have you actually confirmed that there are any cases where isnull(expression)

Re: [GENERAL] isnull() function in pgAdmin3

dudedoe01 schrieb am 27.09.2016 um 19:04: > I am trying to emulate the isnull() function used in MySQL into postreSQL. I > have tried different ways such is null but it's not producing the results > desired. I am doing a data migration from MySQL into postgreSQL and need > help with the isnull()

Re: [GENERAL] isnull() function in pgAdmin3

On 09/27/2016 01:10 PM, dudedoe01 wrote: Thanks Kevin, Igor and Adrian. In MySQL with the isnull() function I get all three values RPG INV, Owner Inventory, and Builder Inventory showed up in the view while when I do the is null function in postgreSQL I only see Builder Inventory and Owner

Re: [GENERAL] isnull() function in pgAdmin3

Maybe your are after IS NOT DISTINCT FROM NULL https://www.postgresql.org/docs/current/static/functions-comparison.html

Re: [GENERAL] isnull() function in pgAdmin3

The tables I migrated from MySQL into postgreSQL have exactly the same amount of rows of data so the problem is inside the view being created. -- View this message in context: http://postgresql.nabble.com/isnull-function-in-pgAdmin3-tp5923122p5923164.html Sent from the PostgreSQL - general

Re: [GENERAL] isnull() function in pgAdmin3

Thanks Kevin, Igor and Adrian. In MySQL with the isnull() function I get all three values RPG INV, Owner Inventory, and Builder Inventory showed up in the view while when I do the is null function in postgreSQL I only see Builder Inventory and Owner Inventory show up in the view. I don't know why

Re: [GENERAL] isnull() function in pgAdmin3

On Tue, Sep 27, 2016 at 12:04 PM, dudedoe01 wrote: > I am trying to emulate the isnull() function used in MySQL into postreSQL. In the future, please describe the results you are trying to achieve or at least describe the semantics of the function from elsewhere that you

Re: [GENERAL] isnull() function in pgAdmin3

On 09/27/2016 10:04 AM, dudedoe01 wrote: Hi, I am trying to emulate the isnull() function used in MySQL into postreSQL. I have tried different ways such is null but it's not producing the results desired. I am doing a data migration from MySQL into postgreSQL and need help with the isnull() in

Re: [GENERAL] isnull() function in pgAdmin3

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of dudedoe01 Sent: Tuesday, September 27, 2016 1:05 PM To: pgsql-general@postgresql.org Subject: [GENERAL] isnull() function in pgAdmin3 Hi, I am trying to emulate

[GENERAL] isnull() function in pgAdmin3

Hi, I am trying to emulate the isnull() function used in MySQL into postreSQL. I have tried different ways such is null but it's not producing the results desired. I am doing a data migration from MySQL into postgreSQL and need help with the isnull() in pgAdmin3. Any assistance provided would be