pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
ERROR:  unexpected SELECT query in exec_stmt_execsql()
2+ messages / 2 participants
[nested] [flat]

* ERROR:  unexpected SELECT query in exec_stmt_execsql()
@ 1999-10-13 07:20 Ismail Kizir <ikizir@teklan.com.tr>
  0 siblings, 0 replies; 2+ messages in thread

From: Ismail Kizir @ 1999-10-13 07:20 UTC (permalink / raw)
  To: pgsql-sql

Hi all,

I had the error message in subject when i ran first time the function below.
Can someone explain me what does it mean and what i must do to avoid it?
Thanks in advance.

Regards
Ismail Kizir

CREATE FUNCTION fOdemesiGereken  (bpchar, int2, int2,boolean) RETURNS float8
AS '
DECLARE
  pOkulNo ALIAS FOR $1; -- Okul numarasý
  pYil ALIAS FOR $2;    -- Yil
  pDonem ALIAS FOR $3;  -- Dönem

  -- Borçlandýrýlan dönem 1. dnm. ise ve öðrenci krediye baþvurmuþsa
borçlandýrýlmaz
  pKrdBasvuraniBorclandirma ALIAS FOR $4;

  tmpint int2;
  IkiliOkuyor boolean;
  Sonuc float8;
  tmpfloat float8;
  OgrRec ogrkutuk%ROWTYPE;
BEGIN
  SELECT * INTO OgrRec from ogrkutuk WHERE okulno = pOkulNo;
  IF NOT FOUND THEN
    RAISE EXCEPTION \'Öðrenci bulunamadý. No : % \', pOkulNo;
  END IF;
  -- Kayýt donduran öðrenci o yýl ve dönem için harç ödemez
  SELECT yil FROM KayitDon INTO tmpint WHERE okulno = pOkulNo AND yil = pYil
AND donem = pdonem;
  IF FOUND THEN
    return 0.0;
  END IF;
  -- Öðrenci ikili öðretimde okuyorsa,
  IF OgrRec.OgrenimTipi = 1 THEN
    SELECT yil FROM IlkYuzdeOn INTO tmpint WHERE okulno = pOkulNo AND yil =
pYil;
    -- Ýlk yüzde ona girdiðinden dolayý normal harç mý ödeyecek?
    IF NOT FOUND THEN
      SELECT IkiliHarc FROM fakdetay INTO sonuc WHERE FBKODU =
OgrRec.FbKodu;
      IF NOT FOUND THEN
        RAISE EXCEPTION \' % kodlu fakültenin % yýlýna ait harç bilgisi
bulunamadý\', OgrRec.FbKodu, pYil;
      END IF;
      IkiliOkuyor := TRUE;
    ELSE
      IkiliOkuyor := FALSE;
      SELECT OrgunHarc FROM fakdetay INTO sonuc WHERE FBKODU =
OgrRec.FbKodu;
      IF NOT FOUND THEN
        RAISE EXCEPTION \' % kodlu fakültenin % yýlýna ait harç bilgisi
bulunamadý\', OgrRec.FbKodu, pYil;
      END IF;
    END IF;
  END IF;

  -- Öðrenci daha önce bir üniversite bitirmiþ ise iki katý harç öder
  IF OgrRec.IkinciUniversite THEN
    Sonuc := Sonuc * 2.0;
  END IF;

  -- Eðer yabancý dilde öðrenim görüyorsa
  -- Ýkili öðrenimde 1.5
  -- Örgün öðrenimde 2 katý harç öder
  IF OgrRec.YabanciDil THEN
    IF IkiliOkuyor THEN
      Sonuc := Sonuc * 1.5;
    ELSE
      Sonuc := Sonuc * 2.0;
    END IF;
  END IF;

  -- Eðer yabancý uyruklu ise,
  IF (OgrRec.Uyruk <> 2425) AND (NOT OgrRec.IkiliAnlasma) THEN
    IF pDonem = 1 THEN
      IF IkiliOkuyor THEN
        Sonuc := Sonuc * 2.0;  -- 2. Öðretimde iki katý
      ELSE
        Sonuc := Sonuc * 3.0;  -- Örgün Öðretimde üç katý
      END IF;
    ELSE
      return 0.0;  -- Yabancý uyruklular ikinci dönemde harç ödemez
    END IF;
  ELSE
    Sonuc := Sonuc / 2.0;  -- Türk uyruklular harcý iki eþit taksitte öder
  END IF;

  -- Normal süresinde bitiremeyenler ilk yýl %50 daha sonra %100 zam öder
  IF NOT (OgrRec.YElliZamBas ISNULL) THEN
    IF pYil = OgrRec.YElliZamBas THEN
      Sonuc := Sonuc * 1.5;
    ELSE
      IF pYil > OgrRec.YElliZamBas THEN
        Sonuc := Sonuc * 2.0;
      END IF;
    END IF;
  END IF;

  -- Eðer pKrdBasvuraniBorclandirma parametresi TRUE ise,
  IF pKrdBasvuraniBorclandirma THEN
    SELECT yil FROM KrediBasvuru INTO tempint WHERE OkulNo = pOkulNo AND Yil
= pYil;
    IF NOT FOUND
      return Sonuc;
    ELSE
      IF pDonem = 1 THEN
        return 0.0;
      END IF;
      return Sonuc * 2;
    END IF;
  END IF;
  return Sonuc;
END;
' LANGUAGE 'plpgsql';





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* ERROR:  unexpected SELECT query in exec_stmt_execsql()
@ 2000-08-15 14:20 Branden R. Williams <brw@kickinit.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Branden R. Williams @ 2000-08-15 14:20 UTC (permalink / raw)
  To: pgsql-sql

Hi.  I am attempting to create a function to do some selects and return
some information.  Pretty straight forward.  No matter what I do, I always
get this error.  Here is my stored function and how I am calling it...

create function sp_list_categories(int4) returns varchar as '
DECLARE
        postid ALIAS FOR $1;
        parentid int4;
BEGIN

        SELECT * FROM category WHERE id = postid;
        parentid := SELECT parent FROM category WHERE id = postid;

        IF parentid ISNULL THEN
                RETURN
        ELSE
                SELECT sp_list_categories(parentid);
                RETURN name;
        END IF;

END;
' LANGUAGE 'plpgsql';


jimmydbase=# select sp_list_categories(20);
ERROR:  unexpected SELECT query in exec_stmt_execsql()

Any and all help would be appreciated!

Branden.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-08-15 14:20 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-10-13 07:20 ERROR:  unexpected SELECT query in exec_stmt_execsql() Ismail Kizir <ikizir@teklan.com.tr>
2000-08-15 14:20 ERROR:  unexpected SELECT query in exec_stmt_execsql() Branden R. Williams <brw@kickinit.net>

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