Search Postgresql Archives

Re: Coditional join of query using PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Coditional join of query using PostgreSQL
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Mon, 15 May 2017 10:26:22 -0700
Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@gmail.com; spf=pass (google.com: best guess record for domain of pgsql-general-owner+m230877=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-general-owner+M230877=spinic=gmail.com@xxxxxxxxxxxxxx; dmarc=pass (p=NONE sp=NONE dis=NONE) header.from=gmail.com
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:cc:to:subject:message-id :date:from:references:in-reply-to:mime-version:dkim-signature :arc-authentication-results; bh=1aSMYk+QoFM19f/3disA+HCWKhzwFWjsQBQANbQ+gDE=; b=fJWuXCdWDgdq8ALP1tzbrJxoC9BPbBfVomT/Uiyr/r/alnqQc1Um//vJ33h0j6dfaU M6PdyT6AInR5x4AAfJTXNR5mO4GALbIeKE9r2h3aKbj3Wk3fUXpxdjHEwSTmgEdtoXG3 JHQGgoGkmk23Zo7Zc6VOyKyLAP9XoEBJbDvm3Rv2QbcvIV3PyhBhnzTw/8H0FVMdhNM9 iDfSSfOrdgdAe5rt1UJOf4C+veftrs/D8G2YqGRgpzOsAm+Yw6XqvRWrP16NB3PJxGKc m3xr0chwUjxt2+CYrxB0aJNHQ71avr6WxS0S0NSbKnTGk8mj4TJ2wDr8MFK4GF1b8JUh x7PA==
Arc-seal: i=1; a=rsa-sha256; t=1494869240; cv=none; d=google.com; s=arc-20160816; b=kPhjyDNre0eJlyIE9ICsslgJ090YP33tMneAp2nrjFZe0CYjIiw1cQewLzybimYMlH V3OEMbe6FXsz+OCWeEC0asweFrrZTs81A2SqRBbY4RhcNNlWjjHw6UcABUrUhvn/uolw +Gnoi6bOZZ+HYSdb3tVLWHr8WxSk9NuRqK6Kad0ehvmoYXiFvuxRCE75k1JEYaiTDbix 3rYdOuKpmT0+QAACKcuZGCLiJl5r6mr3w4gZ8mieMVUgXVuR8XX4G1j5JEvRkJS3zwAn jq6OXeGPTrIKQPFuObrh1ImMjOlJYFhwslbGsOYXPzDb2sYg7sJXZqNF/V2YczWzSD2s jSZg==
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <~0025919DF0C883205006078@walla.co.il>
References: <~0025919DF0C883205006078@walla.co.il>

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Coditional join of query using PostgreSQL
  - From: Jack

References:
- Coditional join of query using PostgreSQL
  - From: Nick Dro

Prev by Date: Re: Insert performance and disk usage in JSON vs JSONB
Next by Date: Re: Coditional join of query using PostgreSQL
Previous by thread: Coditional join of query using PostgreSQL
Next by thread: Re: Coditional join of query using PostgreSQL
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]