Peter Eisentraut wrote:
> sad writes:
>
> > The first problem using temp table is:
> >
> > CREATE TABLE locals (name text, value text);
> >
> > CREATE OR REPLACE FUNCTION test_locals_access() RETURNS text AS '
> > DECLARE i text;
> > BEGIN
> > SELECT value INTO i FROM locals WHERE name=''n1''
> >
_
Need a naukri? Your search ends here. http://www.msn.co.in/naukri/ 50,000 of
the best jobs!
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://
sad writes:
> The first problem using temp table is:
>
> CREATE TABLE locals (name text, value text);
>
> CREATE OR REPLACE FUNCTION test_locals_access() RETURNS text AS '
> DECLARE i text;
> BEGIN
> SELECT value INTO i FROM locals WHERE name=''n1''
> RETURN i;
> END;
> ' LANGUAGE 'plpgsql';
>
> S
Hello,
I've got a question about "LIKE" phrase. I have such a phrase:
LIKE UPPER(Key_Zawod)
And I want to write after Key_Zawod % but it doesn't work. Is there any special way to code this phrase?
like upper(key_zawod) || '%'
Regards,
Tomasz Myrta
---(end of broadcast)-
Hello,
I've got a question about "LIKE" phrase. I have such a phrase:
LIKE UPPER(Key_Zawod)
And I want to write after Key_Zawod % but it doesn't work. Is there any special way to
code this phrase?
--
greetings
Michał Wróblewski #GG: 111769 #ICQ: 113904213
Administrator Sieci SSK Ligota: ww
