Re: [SQL] plpgsql language not aware of standard_conforming_strings ?

"Sabin Coanda" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > "Sabin Coanda" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > ... >> >> How can I get my desired function that means when I call test( 'a\b' ) it >> will return 'a\\b' ? >> > ... > CREATE OR REPLACE

Re: [SQL] plpgsql language not aware of standard_conforming_strings ?

"Sabin Coanda" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] ... > > How can I get my desired function that means when I call test( 'a\b' ) it > will return 'a\\b' ? > The problem seems to be the constant evaluation in plpgsql functions which is not aware of standard_conforming_

[SQL] plpgsql language not aware of standard_conforming_strings ?

Hi there, Having standard_conforming_strings = 'on', I build the following scenario. I request SELECT replace( 'a\b', '\', '\\' ), which get me the result: replace - a\\b I'd like to build a function that give me the same result, as: CREATE OR REPLACE FUNCTION "test"(s varchar) RET

Re: [SQL] PLPGSQL language documentation

I'll second the suggestion about looking at Oracle PL/SQL materials. I used an introductory PL/SQL text when learning about PLpgSQL, and found it very useful. The syntax/functionality is highly similar (by design, apparently). Much of the Oracle PL/SQL functionality is not (yet) implemented in P

Re: [SQL] PLPGSQL language documentation

Hear hear! We have been looking for it as well! We have avoided using triggers to date because we do not know how to program in the language! Sandy Ear wrote: > I was wondering if anyone knew of good online documentation on PlPgsql? > > > > > > ---(end of broadcast)

Re: [SQL] PLPGSQL language documentation

Sandy, > I was wondering if anyone knew of good online documentation on PlPgsql? Read two things: 1. the online docs for PostgreSQL 7.2 under "Programmer's guide: Procedural Languages" 2. Roberto' Mello's enhanced documentation, accessable through techdocs.postgresql.org. Roberto also has a

[SQL] PLPGSQL language documentation

I was wondering if anyone knew of good online documentation on PlPgsql? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] plpgsql language

On Wed, Jan 24, 2001 at 01:39:48PM +0800, chard wrote: > hello, > i got this error when i tried to create a function > "unrecognized language specified in CREATE FUNCTION: 'plpgsql'" why is > that? man createlang -- -- Al

[SQL] plpgsql language

hello, i got this error when i tried to create a function "unrecognized language specified in CREATE FUNCTION: 'plpgsql'" why is that?