Re: [SQL] Programatically switching database

2003-11-16 Thread Greg Stark
ow <[EMAIL PROTECTED]> writes: > My concern though ... wouldn't pgSql server collapse when faced with > transaction spawning across 100M+ records? The number of records involved really doesn't faze Postgres at all. However the amount of time spent in the transaction could be an issue if there is

Re: [SQL] Addition and subtraction on BIT type

2003-11-16 Thread Stephan Szabo
On Sun, 16 Nov 2003, Yasir Malik wrote: > I think I am almost at a solution to my last question. I can do > select int4(a) from test; > to convert to an integer. So now addition and > subtraction can be done between bit types. But how do I convert back to > BIT type? If I do > select bit(int4(

Re: [SQL] WITHOUT OIDS by default

2003-11-16 Thread Bruce Momjian
ow wrote: > Hi, > > Is there a way to specify that all tables should be created WITHOUT OIDS by > default? No, and strangely it wasn't on the TODO list. I just added it: * Add GUC setting to make created tables default to WITHOUT OIDS -- Bruce Momjian| http:

Re: [SQL] Addition and subtraction on BIT type

2003-11-16 Thread Yasir Malik
Hello, I think I am almost at a solution to my last question. I can do select int4(a) from test; to convert to an integer. So now addition and subtraction can be done between bit types. But how do I convert back to BIT type? If I do select bit(int4(b'1001')); I get the following message: ERROR

[SQL] WITHOUT OIDS by default

2003-11-16 Thread ow
Hi, Is there a way to specify that all tables should be created WITHOUT OIDS by default? Thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ---(end of broadcast)-

[SQL] Addition and subtraction on BIT type

2003-11-16 Thread Yasir Malik
Hello, Is there a way to do addition and subtraction on BIT types? For example, for creat table test (a BIT(3)); insert into test values (B'101'); select a + 1 from test; fails and select a::smallint + 1 from test; also fails. In addition, is there a way to change the bit of a bit string? For

Re: [SQL] Programatically switching database

2003-11-16 Thread Christopher Browne
Clinging to sanity, [EMAIL PROTECTED] (Tom Lane) mumbled into her beard: > ow <[EMAIL PROTECTED]> writes: >> My concern though ... wouldn't pgSql server collapse when faced with >> transaction spawning across 100M+ records? > > No. You're extrapolating from Oracle-specific assumptions again. Or f

Re: [SQL] Programatically switching database

2003-11-16 Thread Tom Lane
ow <[EMAIL PROTECTED]> writes: > My concern though ... wouldn't pgSql server collapse when faced with > transaction spawning across 100M+ records? No. You're extrapolating from Oracle-specific assumptions again. regards, tom lane ---(end of broadc

Re: [SQL] schema

2003-11-16 Thread Rüdiger Flotmann
look here http://sql-info.de/postgresql/schemas.html On Sun, 16 Nov 2003 13:05:20 +0530 Kenneth Gonsalves <[EMAIL PROTECTED]> wrote: > hi > where can i find infor about 'schema' in postgresql? ---(end of broadcast)--- TIP 2: you can get off all li

[SQL] schema

2003-11-16 Thread Kenneth Gonsalves
hi where can i find infor about 'schema' in postgresql? -- regards kg http://www.ootygolfclub.org ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match