Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] standards question

From: "Kent S(dot) Gordon" <kgor(at)inetspace(dot)com>
To: meskes(at)topsystem(dot)de
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] standards question
Date: 1998-03-18 19:28:44
Message-ID: 199803181928.NAA09130@soccer.inetspace.com (view raw or flat)
Thread:
Lists: pgsql-hackers
>>>>> "meskes" == Michael Meskes <meskes(at)topsystem(dot)de> writes:

    > Is there a standard that defines how to return information from
    > an embedded SQL statement? ORACLE uses the sqlca. In particular
    > it uses sqlca.sqlerrd[2] for affected tuples. Is this correct
    > with the standards? How do other systems do that? 

 sqlca is fairly standard in most databases.  It was the recommended method of
doing exception handling in the past.  The SQL2 (SQL/92) standard went
to using SQLSTATE variable and GET DIAGNOSISTICS statement.

    > Michael -- Dr. Michael Meskes, Project-Manager | topsystem
    > Systemhaus GmbH meskes(at)topsystem(dot)de | Europark A2,
    > Adenauerstr. 20 meskes(at)debian(dot)org | 52146 Wuerselen Go SF49ers!
    > Go Rhein Fire!  | Tel: (+49) 2405/4670-44 Use Debian GNU/Linux!
    > | Fax: (+49) 2405/4670-10

-- 
Kent S. Gordon
Architect
iNetSpace Co.
voice: (972)851-3494 fax:(972)702-0384 e-mail:kgor(at)inetspace(dot)com

In response to

pgsql-hackers by date

Next:From: Tom Ivar HelbekkmoDate: 1998-03-18 21:50:35
Subject: Re: [HACKERS] Re: [PATCHES] patches for 6.2.1p6
Previous:From: Peter T MountDate: 1998-03-18 19:06:15
Subject: Re: [QUESTIONS] Inheriting Triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group