Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Coditional join of query using PostgreSQL - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Coditional join of query using PostgreSQL
Date
Msg-id CAKFQuwa4QJNQFcC7GHREA8aKM7sFHUZMnrfcBtROCkt0229+mw@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Coditional join of query using PostgreSQL  (Nick Dro <postgresql@walla.co.il>)
Responses Re: [GENERAL] Coditional join of query using PostgreSQL
List pgsql-general
Tree view
On Mon, May 15, 2017 at 10:02 AM, Nick Dro <postgresql@walla.co.il> wrote:
Hi,
I'm new to postgresql and couldn't find answer to this situation anywhere.
I asked this here:
http://stackoverflow.com/questions/43984208/coditional-join-of-query-using-postgresql

I hope there is a better solution rather than creating two separated functions :(

​Generate the SQL itself in a string then execute the string.  Its called "Dynamic SQL"​.

https://www.postgresql.org/docs/9.6/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

David J.

pgsql-general by date:

Previous
From: Ronny Abraham
Date:
Subject: Re: [GENERAL] Insert performance and disk usage in JSON vs JSONB
Next
From: Jack
Date:
Subject: Re: [GENERAL] Coditional join of query using PostgreSQL