Hi There,
If you omit the column names, the values are assumed to follow the order
of the column names in the table definition. So if you have the columns
with default values at the end of the table definition, then you don't
need to insert a value for them. Same as in C.
It is better practice
Hi all,
Let's say I have a table named "info" having the following fields:
name char(40),
surname char(40),
address char(40),
id serial
Now, since id is a serial, while inserting data into info I write:
INSERT INTO info (name,surname,address) VALUES ('$name','$surname',
'#address');
Is there
On 28 Sep 2001, Wei Weng wrote:
> Hi there. I wrote a simple postgresql sql function as follows:
>
> create function test() returns integer as '
> begin
> fixed_path := translate (''/text'', ''\\'', ''/'');
> raise notice ''fixed_path:'', fixed_path;
> return 1;
> end
> ' language 'plpgsql';
>
I've tried (column indexdef is of type text)
select indexdef from pg_indexes where indexdef like '%pg_proc%' ;
select indexdef from pg_indexes where position('pg_proc' in indexdef) > 0 ;
select upper(indexdef) from pg_indexes where position('pg_proc' in indexdef) > 0 ;
and all three worked as
