[SQL] plpgsql ?

[guard]

Hi all,

i have a question 'plpgsql'

my code

CREATE FUNCTION autono (text,text) RETURNS text AS '
  DECLARE
a1 ALIAS FOR $1;
a2 ALIAS FOR $1;
ret_val text;
  BEGIN
select tna  into ret_val from a1  where pamt_no=a2;

  RETURN ret_val;
END;' LANGUAGE 'plpgsql'


error run  "   select tna  into ret_val from a1  where pamt_no=a2;"
help me ,thanks

[SQL] create default

[guard]

hi,how to set default filed+field

create table "table1"(
  "cno1" char(10)  default NEW.cno2+NEW.cno3,
  "cno2" char(10) ,
  "cno3" char(10)
);

I try pl/pgsql and pl/tcl  NOT RUN,

thanks

[SQL] Distributed database ?

[guard]

how to run "select from databaseA:tabl1 ,databaseB:table2 "

thanks

[SQL] pltcl how to get array value

[guard]

> HI, All!
>
> How can I try
>
> set abc {5,6,7,8}
> return abc{0}   # return 5
>
> pltcl
>
> thanks

[SQL] how to simulate UPdate ...?

[guard]

I not run update in Pgsql

please tell me other method
thanks

==
update table1 a set na1=
(select table2.na1 from table2,table1
where table1.no=table2.no
and a.no=table1.no);

[SQL] how to download postgresql 7.1 beta

[guard]

thanks

[SQL] [ADMIN] look online connection & user name

[guard]

thanks

[SQL]how to select * from database1 table,database2 table

[guard]

if join database1 database2how to makeI use VB 
or DELPHIthanks

[SQL]how to select * from database1 table,database2 table

[guard]

if join database1 database2

how to make

I use VB or DELPHI

thanks

[SQL] int2+float8 problems

[guard]

select trn_qty,amount2,trn_qty*amount2 from invo

trn_qty INT2
amount2 FLOAT8

+-+-+--+
| trn_qty | amount2 | ?column? |
+-+-+--+
|  -1 |7678 | 7678 |

what to get -7678

thanks

Re: [SQL] int2+float8 problems

[guard]

compile   ./configure  --prefix=/home/pgsql --enable-multibyte
run Redhat 6.1 & 6.2
postgresql7.0.3
not run regression tests






"Tom Lane" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "guard" <[EMAIL PROTECTED]> writes:
> > select trn_qty,amount2,trn_qty*amount2 from invo
> > trn_qty INT2
> > amount2 FLOAT8
>
> > +-+-+--+
> > | trn_qty | amount2 | ?column? |
> > +-+-+--+
> > |  -1 |7678 | 7678 |
>
> What platform are you on, and how did you compile Postgres?
> Also, what Postgres version?  Did you run the regression tests?
>
> regards, tom lane

[SQL] postgresql beta-4,5 BUG

[guard]

DELPHI can't use TABLE component



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] help pgsql 7.1beta & delphi

[guard]

pgsql 7.1 beta.. NOT USE Delphi "Ttable" component






---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[SQL] get all online user?

[guard]

hi

How to get all online user name?
thanks





---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[SQL] update error

[guard]

I try

update table_a set trn_no = table_b.trn_no from table_a,table_b
where table_a.cust_no=table_b.cust_no

IN pgsql 7.0x  IS OK

if run 7.1 IS error ??






---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] nullif BUG???

[guard]

I try

> select nullif(NULL,5)

++
| case   |
++
|  |
++



--




---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] select 5/2???

[guard]

dear all

I run select 5/2  = 2
who to get "2.5"

thanks


--




---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] Lock full database

[guard]

dear all

I want lock full tables,how to write SQL command?
thanks



--




---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] can't update 'c:\windows'

[guard]

thanks. your reply



--

""Josh Berkus"" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó·s»D
:[EMAIL PROTECTED]
> Guard,
>
> First, this kind of beginner question is more appropriate for the NOVICE
> list.
>
> > IF update table set field='c:\windows'
> > but
> >
> > c:\windows -> c:windows
>
> That's because "\" is the Unix escape character.  If I were to want to
> save "O'Reilly", for example, I could:
> UPDATE table SET name = 'O\'Reilly';
>
> Since you want to save an actual backslash, do this:
>
> UPDATE table SET field = 'C:\\windows';
>
> In your interface code, you may which to add a function that doubles
> your backslashes.
>
> -Josh Berkus
>
>
> __AGLIO DATABASE SOLUTIONS___
>Josh Berkus
>   Complete information technology  [EMAIL PROTECTED]
>and data management solutions   (415) 565-7293
>   for law firms, small businessesfax 621-2533
> and non-profit organizations.  San Francisco
>
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] can't update 'c:\windows'

[guard]

dear all

IF update table set field='c:\windows'
but

c:\windows -> c:windows

--




---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [SQL] to_char()??

[guard]

thanks

I have run "select substr('hi there', 3, 5)::varchar(5) as xx;"
but get error message
Error: ERROR:  parser: parse error at or near ":"

--

"Lee Harr" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó·s»D
:9qd0j0$1gc3$[EMAIL PROTECTED]
> >
> > how to
> > select substr('hi there',3,5) as xx   -->>  xx change char type
> >
>
> How about:
>
> select substr('hi there', 3, 5)::varchar(5) as xx;
>
> or is this not what you mean?
>



---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster