pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew G. Hammond <drew@xyzzy.dhs.org>
To: Fernández Mariano <mfernandez@infoauto.gov.ar>
To: pgsql-sql@postgresql.org
Subject: Re: Stored Procedure
Date: Sat, 24 Nov 2001 04:48:10 -0500
Message-ID: <E167ZPx-00050l-00@xyzzy.lan.internal> (raw)
In-Reply-To: <006101c17291$6fa84e50$3201010a@mariano>
References: <006101c17291$6fa84e50$3201010a@mariano>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 2001 November 21 08:35 am, Fernández Mariano wrote:
> Hello Pasha
>
>     I'm trying to create a function that return a (select * from table1,
> table2..where attrib = $1...) of join. But I can't make this. Like to
> Stored Procederue in MS-SQL Server
>     Can you help me?

Looks more like you want a VIEW.  For example:

CREATE TABLE a (id SERIAL PRIMARY KEY, name TEXT);
CREATE TABLE b (id SERIAL PRIMARY KEY,  data TEXT, 
  key_a INTEGER REFERENCES a(id));
CREATE VIEW c AS SELECT name, data FROM a, b WHERE a.id = b.key_a;

Then simply SELECT from the VIEW.

- -- 
Andrew G. Hammond     mailto:drew@xyzzy.dhs.org   http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F                  613-389-5481
5CD3 62B0 254B DEB1 86E0  8959 093E F70A B457 84B1
"To blow recursion you must first blow recur" -- me
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAjv/bNsACgkQCT73CrRXhLFGkQCfbEwNXXH7/frMpprQtccQ/bEA
J5kAnjgH1z/BzRX4WFnS9rFgIRPg2r3H
=lrRa
-----END PGP SIGNATURE-----



view thread (2+ messages)

Message-ID: <E167ZPx-00050l-00@xyzzy.lan.internal>
Permalink:  ../E167ZPx-00050l-00@xyzzy.lan.internal/
Also on:    postgresql.org/message-id/E167ZPx-00050l-00@xyzzy.lan.internal

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: drew@xyzzy.dhs.org, mfernandez@infoauto.gov.ar
  Subject: Re: Stored Procedure
  In-Reply-To: <E167ZPx-00050l-00@xyzzy.lan.internal>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox