pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gary Stainburn <gary.stainburn@ringways.co.uk>
To: omid omoomi <oomoomi@hotmail.com>
To: gary.stainburn@ringways.co.uk
To: pgsql-sql@postgresql.org
Subject: Re: My First Function
Date: Tue, 3 Jul 2001 17:08:06 +0100
Message-ID: <01070317080604.03765@gary.ringways.co.uk> (raw)
In-Reply-To: <F194zSgDvai2RJ8m4ZQ0001b6eb@hotmail.com>
References: <F194zSgDvai2RJ8m4ZQ0001b6eb@hotmail.com>

Okay, thanks for that.

I'm getting far enough with my SQL to be able to read and understand that 
one, but how do I put that into a plsql function and how do I call it.

Lets asume I've changed the relationship so that there is only one person per 
position, so only one integer should be returned.  How do I get that integer 
returned to my perl/php script, and how do I return -1 if the result of the 
query is empty?

Gary

On Sunday 01 July 2001  5:39 pm, omid omoomi wrote:
> >I want to be able to pass a member ID and a function ID and return the
> >highest permission for the two.  The cut-down schema is:
>
> Hello ,
> Perhaps this SQL works for you:
>
> select PPID,Max(PPERM)
> from permtable
> where
> PFID = 'FUNCTION_ID'
> and
> PPID in ( select HPID from holdertable where HMID='MEMBER_ID' )
> group by PPID;
>
> You will face some problems returning more than one value from this SQL if
> using it in a function.
> Though,I believe if you are going to use a PHP script it can easilly be
> handled with it.
>
> Hope that helps
> Omid Omoomi
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     



view thread (6+ messages)  latest in thread

Message-ID: <01070317080604.03765@gary.ringways.co.uk>
Permalink:  ../01070317080604.03765@gary.ringways.co.uk/
Also on:    postgresql.org/message-id/01070317080604.03765@gary.ringways.co.uk

 · 

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: gary.stainburn@ringways.co.uk, oomoomi@hotmail.com
  Subject: Re: My First Function
  In-Reply-To: <01070317080604.03765@gary.ringways.co.uk>

* 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