Re: Coditional join of query using PostgreSQL

[Nick Dro <postgresql@xxxxxxxxxxx>]

This is a join in a middle of query.

How can I use dynamic SQL in the middle of query?

ב מאי 15, 2017 20:26, David G. Johnston כתב:

On Mon, May 15, 2017 at 10:02 AM, Nick Dro <postgresql@xxxxxxxxxxx> 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.