Re: [SQL] Don't understand creation statement's answer

On Mon, 18 Dec 2000 12:32, Thomas SMETS wrote: > Hi, > > In the long term I'm willing to construct a Little Java application that > runs a library. you might find http://www.koha.org interesting Library management on all free software. -- Sincerely etc., NAME Christopher Sawtell CELL

Re: [SQL] How to set autocommit on/off

Hi, there, I think you can use : BEGIN;-- turn off any DDL stmts -- you can rollback them by ROLLBACK; END|COMMIT; -- turn on Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.ipinc.com On Wed,

Re: [SQL] `~' operator and indices

Hi, there, Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.ipinc.com On Wed, 20 Dec 2000, Artur Rataj wrote: > Hello, > > I would like to ask you why do `~' gives the following results, > if there is an in

Re: [SQL] plpgsql ?

Hi, there, see following. Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.ipinc.com On Wed, 20 Dec 2000, guard wrote: > Hi all, > > i have a question 'plpgsql' > > my code > > CREATE FUNCTION autono (te

[SQL] sorting the text values as integers

Hi, i have a table with some text fields filled with a data like 100,23 235,12 500 200 the same fields somethimes contains the values like 100x100x25 125x125x50 200x80x90 and so on. the client requires that rows are sorted in ascending order for the case there are a float values, i

Re: [SQL] plpgsql ?

> 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

Re: [SQL] how to alter/drop check contraint?

There's no good way currently to drop the check constraint really. You probably can do it by removing the row for the constraint from pg_relcheck and changing the pg_class row for the table to have the correct number in relchecks. In 7.1, you'd probably be able to add the check constraint using

[SQL] `~' operator and indices

Hello, I would like to ask you why do `~' gives the following results, if there is an index on `string': select string from indextbk_fti_fkey where string ~ '^IE'; string (0 rows) select string from indextbk_fti_fkey where string ~ '^IECIA'; string IECIA (1 row) `E' here

[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

[SQL] How to set autocommit on/off

As titled, is autocommit of Postgresql is default to be "ON", how to turn it off then? Thnaks, Kevin -- - Kevin LAM, System Analyst Crown Development Ltd. A Shun Tak Group Company Tel: (852) 2283-2132 Fax:(852) 2283-2727 -

Re: [SQL] Create table doesn't work in plpgsql

Hi,there, I don't think you can use DDL(data definition language) in PL/SQL. create table is not DML(data munipulation language) instead it's a DDL. Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 [EMAIL PROTECTED] www.ipinc.com

Re: [SQL] substring ..

Hi,there, I am not sure what is your question mean. However, if the type of datefoo is a timestamp then try: select foo from table where date(datefoo) = '2000-12-14'; select foo from table where datefoo::date = '2000-12-14'::date; select foo from table where substr(datefoo,1,10) = '2000-12-14';

[SQL] how to alter/drop check contraint?

the subject should be self-explanatory, but: i have table: create table a (b text check (length(b)<10)); and for some reason i want to drop this check or alter this to length(b)<20. how can i do so? or maybe using trigger in plpgsql will be better? how to make trigger which will stop insert or up