Re: [GENERAL] How do you live without OUTER joins? - Mailing list pgsql-general

On Tue, 11 Jan 2000, Bruce Bantos wrote:
> In my current Oracle DB, I have a number of "lookup" tables
> that contain something like this:

You make a "lookup" function, and you call the
function in your select list.

It's been a few months since I've played with
PostgreSQL, so I don't remember the syntax.

An Oraclish example:

CREATE FUNCTION LOOKUP_CATEGORY_LONG_(VARCHAR2 ABBREV)
AS
  myVar  COMPANY_CATEGORY.COM_CAT_LONG%TYPE;
BEGIN
  SELECT COM_CAT_LONG
   INTO  myVar
    FROM COMPANY_CATEGORY
   WHERE COM_CAT_ABBR = ABBREV;
  RETURN myVar;
END;


SELECT COMPANY_NAME, LOOKUP_CATEGORY_LONG(COM_CAT_ABBR) CATEGORY
  FROM COMPANY;