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

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

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

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

[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

Re: [GENERAL] pgAdmin 4 records limit of 2000

Hi Adrian, The query tool toolbar is disabled in my pgAdmin 4. Is there anyway I can enable it. -- View this message in context: http://postgresql.nabble.com/pgAdmin-4-records-limit-of-2000-tp5919751p5919825.html Sent from the

[GENERAL] pgAdmin 4 records limit of 2000

Hi, I have pgAdmin 9.4. I can only view 2000 rows of data at a time in pgAdmin 4 while the previous version 9.3 there was no limit. Is there anyway to remove the limit on the rows of data I can see all the data concurrently. Please provide insights. Thanks in Advance,