From fillons@offratel.nc Wed Sep 15 16:17:30 1999 Received: from mail_dns.lagoon.nc (mail.offratel.nc [209.58.55.28]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA99094 for ; Wed, 15 Sep 1999 12:17:30 -0400 (EDT) (envelope-from fillons@offratel.nc) Received: from portable (unverified [209.58.55.182]) by mail_dns.lagoon.nc (Rockliffe SMTPRA 3.4.3) with SMTP id for ; Thu, 16 Sep 1999 03:19:10 +1100 Message-ID: <002d01beff95$d70fcee0$b6373ad1@portable> From: "=?iso-8859-1?Q?St=E9phane_FILLON?=" To: "pgsql-sql" Subject: CREATE FUNCTION Date: Thu, 16 Sep 1999 03:17:27 +1100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002A_01BEFFF2.00B54200" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 This is a multi-part message in MIME format. ------=_NextPart_000_002A_01BEFFF2.00B54200 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi ! I would like to know why I can't create a function with a parameter of = type char(10). Thanks in advance. Stephane FILLON ------=_NextPart_000_002A_01BEFFF2.00B54200 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi !
 
I would like to know why I can't = create a=20 function with a parameter of type char(10).
 
Thanks in advance.
 
Stephane = FILLON
------=_NextPart_000_002A_01BEFFF2.00B54200-- From jose@sferacarta.com Thu Sep 16 12:51:12 1999 Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA87492 for ; Thu, 16 Sep 1999 08:51:12 -0400 (EDT) (envelope-from jose@sferacarta.com) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.9.3/8.9.3/NETTuno 3.3) with ESMTP id OAA10408; Thu, 16 Sep 1999 14:50:51 +0200 (MDT) Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 11RcmD-00076x-00; Thu, 16 Sep 1999 14:44:45 +0000 Message-ID: <37E0E76D.84BCE9D4@sferacarta.com> Date: Thu, 16 Sep 1999 14:49:49 +0200 From: =?iso-8859-1?Q?Jos=E9?= Soares X-Mailer: Mozilla 4.5 [it] (Win95; I) X-Accept-Language: it MIME-Version: 1.0 To: =?iso-8859-1?Q?St=E9phane?= FILLON CC: pgsql-sql Subject: Re: [SQL] CREATE FUNCTION References: <002d01beff95$d70fcee0$b6373ad1@portable> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Try bpchar instead of char. José Stéphane FILLON ha scritto: > Part 1.1 Type: Plain Text (text/plain) > Encoding: quoted-printable From nohejl@winet.cz Mon Apr 9 11:39:00 2001 Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f39Bd0828537 for ; Mon, 9 Apr 2001 07:39:00 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from winet.cz (ns1.winet.cz [194.149.103.117]) by postgresql.org (8.11.3/8.11.1) with SMTP id f398gb892727 for ; Mon, 9 Apr 2001 04:42:53 -0400 (EDT) (envelope-from nohejl@winet.cz) Received: (qmail 22414 invoked from network); 9 Apr 2001 08:42:04 -0000 Received: from winternet.nextra.cz (HELO ericek) (195.70.156.246) by ns.winet.cz with SMTP; 9 Apr 2001 08:42:04 -0000 Message-ID: <002d01c0c0d0$fe70a6a0$7d4010ac@winet.cz> From: =?iso-8859-2?B?VG9t4bkgTm9oZWps?= To: "pg-sql" Subject: create function Date: Mon, 9 Apr 2001 10:42:20 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002A_01C0C0E1.C0DC1FC0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200104/118 X-Sequence-Number: 2465 This is a multi-part message in MIME format. ------=_NextPart_000_002A_01C0C0E1.C0DC1FC0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable How Can I Create function delete from... with returns opague and without pl= pgsql language.=20 Sample: create function fdel returns opaque as 'delete from tab;' language 'sql'; Thanks. Tomas N. ------=_NextPart_000_002A_01C0C0E1.C0DC1FC0 Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable
 
How Can I Create function delete from= ... with=20 returns opague and without plpgsql language.
 
Sample:
 
create function fdel returns= opaque=20 as 'delete from tab;' language 'sql';
Thanks.
 
Tomas N.
------=_NextPart_000_002A_01C0C0E1.C0DC1FC0--