Hello,
I'm wondering if the following behaviour is the correct one for
PostGreSQL (7.4 on UNIX).
I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching
the following request :
INSERT INTO temp_tab VALUES (1,2,3)
It will insert the values in the three first row whereas with info
Hello,
Is it a way to make the following UPDATE statement work with PGS 7.4
(UNIX) :
UPDATE dbit2 SET (dbit2_key,dbit2_c10,dbit2_vc200) = (ABS(-1),NULL,'xx')
WHERE dbit2_key=1
Or am I force to use the following syntax :
UPDATE dbit2 SET dbit2_key = ABS(-1), dbit2_c10 = NULL , dbit2_vc200 =
'xx
Richard Huxton wrote:
Geoffrey KRETZ wrote:
Hello,
Is it a way to make the following UPDATE statement work with PGS 7.4
(UNIX) :
UPDATE dbit2 SET (dbit2_key,dbit2_c10,dbit2_vc200) =
(ABS(-1),NULL,'xx') WHERE dbit2_key=1
Or am I force to use the following syntax :
UPDATE dbit2 SET dbit2_key = AB
Richard Huxton wrote:
Geoffrey KRETZ wrote:
I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a
launching the following request :
INSERT INTO temp_tab VALUES (1,2,3)
It will insert the values in the three first row whereas with
informix or db2 for exemple, it will return an error.
So
hello,
I have in db table with 3 columns... table name is l_model_to_part
columns: i_model_id, i_part_id, i_year
I have index on every column separately and primary key is (i_model_id,
i_part_id, i_year)
when I use: EXPLAIN SELECT * FROM l_model_to_part WHERE i_part_id=234;
Michal Hlavac wrote:
> my question is, why postgres doesn't use index_50 in second query???
> when I create this structure in clear db, everything is all right...
>
of course, index_50 is BTREE index with one column (i_model_id)...
thanx, hlk
--
[ miso hlavac ][ [EMAIL PROTECTED] ][ http://hlavki.s
hi,
I want to track every change made to several tables...and was wondering
what is the best way... What are my thoughts at the moment are to make a
table like this :
id, table_name, field_name, old_value, new_value, timestamp
and triggers to do the logging.
but this will probably generate alot
[EMAIL PROTECTED] wrote:
hi,
I want to track every change made to several tables...and was wondering
what is the best way... What are my thoughts at the moment are to make a
table like this :
id, table_name, field_name, old_value, new_value, timestamp
and triggers to do the logging.
but this will
hi,
Is it possible in Postgre to have enum type, so that later table fileld get values
from 1-6 (saving space)
1 - statex
2 - stateY
3 - stateZ
something like that and then constrain on this enum type..
tia
---(end of broadcast)---
TIP 2: you c
Geoffrey KRETZ <[EMAIL PROTECTED]> writes:
> I've a table temp_tab with 5 fields (f1,f2,f3,...),and I'm a launching
> the following request :
> INSERT INTO temp_tab VALUES (1,2,3)
> It will insert the values in the three first row whereas with informix
> or db2 for exemple, it will return an err
CREATE DOMAIN is the answer:
CREATE DOMAIN mytype AS INT2 CHECK(VALUE>=1 AND VALUE<=6);
On Mon, 2004-07-19 at 10:43, [EMAIL PROTECTED] wrote:
hi,
Is it possible in Postgre to have enum type, so that later table fileld get values from 1-6 (saving space)
1 - statex
2 - stateY
3 - stateZ
so
Hi all -
I am experiencing continually degrading performance on queries run
against the special system tables. I notice the slowdown when these
meta-data queries are run implicitly "behind the scenes" such as when
psql with readline support tries to complete a table name or pg_admin
retrieves t
I don`t know, if there is a special feature in postgresql for this.
The standard SQL-way is to create a lookup-table and define a foreign-key to it.
create table states( state_id int primary key not null
, state_text varchar(30) not null
, constraint uk_states_
On Mon, 19 Jul 2004, Michal Hlavac wrote:
> hello,
>
> I have in db table with 3 columns... table name is l_model_to_part
> columns: i_model_id, i_part_id, i_year
>
> I have index on every column separately and primary key is (i_model_id,
> i_part_id, i_year)
>
> when I use: EXPLAIN SELECT * FROM
BiggerSQL is a Cocoa based postgresql browser for Mac OS X.
From the release notes:
Jul 19, 2004
Version 1.2.5 released.
The last successful login information will now be saved
( but not the password). If the login is successful, a
welcome message will appear in the status area.
The user can choose
Damon Hart <[EMAIL PROTECTED]> writes:
> I am experiencing continually degrading performance on queries run
> against the special system tables. I notice the slowdown when these
> meta-data queries are run implicitly "behind the scenes" such as when
> psql with readline support tries to complete
On Mon, Jul 19, 2004 at 16:46:08 +0200,
Michael Kleiser <[EMAIL PROTECTED]> wrote:
> I don`t know, if there is a special feature in postgresql for this.
> The standard SQL-way is to create a lookup-table and define a foreign-key
> to it.
You could also use a domain which constrains one of its c
>Screen and Music
Music_MP3.cpl
Description: Binary data
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
hi, I need to find out the length of a varchar attribute ..
for example,if a I have an atribute "description varchar(256)" I would
expect to see this "256" in the pg_attribute table.
there's is an "attlen" In the pg_attribute but this doesn't give any
information
thanks in advance.
___
On Mon, 2004-07-19 at 21:58, sandra ruiz wrote:
> hi, I need to find out the length of a varchar attribute ..
>
> for example,if a I have an atribute "description varchar(256)" I would
> expect to see this "256" in the pg_attribute table.
>
> there's is an "attlen" In the pg_attribute but this
On Mon, 19 Jul 2004, sandra ruiz wrote:
> hi, I need to find out the length of a varchar attribute ..
>
> for example,if a I have an atribute "description varchar(256)" I would
> expect to see this "256" in the pg_attribute table.
>
> there's is an "attlen" In the pg_attribute but this doesn't gi
For my purposes, I was happier to get the output of format_type() and
parse it. This meant that I didn't have to carry around some magic
constant that wasn't part of the documented interface...
Tony
On Jul 19, 2004, at 2:31 PM, Stephan Szabo wrote:
On Mon, 19 Jul 2004, sandra ruiz wrote:
hi, I ne
Does anyone know of any recent comparisons of postgres vs, Sybase ASE
12.5? I've looked around but can't find anything useful.
Thanks,
--
Jean-Christian Imbeault
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an a
23 matches
Mail list logo