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

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' &

[SQL] Lock full database

dear all I want lock full tables,how to write SQL command? thanks -- ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

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

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()??

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

[SQL] select 5/2???

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] nullif BUG???

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] update error

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] get all online user?

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 clea

[SQL] help pgsql 7.1beta & delphi

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 l

[SQL] postgresql beta-4,5 BUG

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])

Re: [SQL] int2+float8 problems

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]

[SQL] int2+float8 problems

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

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

if join database1 database2 how to make I use VB or DELPHI thanks

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

if join database1 database2how to makeI use VB or DELPHIthanks

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

thanks

[SQL] how to download postgresql 7.1 beta

thanks

[SQL] how to simulate UPdate ...?

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] pltcl how to get array value

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

[SQL] Distributed database ?

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

[SQL] create default

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] plpgsql ?

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 " sel