Re: [SQL] Wicked screensaver

Please see the attached file for details. ---(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] Inheritance or no inheritance, there is a question

Vernon, > Thanks for your suggestion. I haven't thought this structure, to compose a > table with another one. That probably is the best solution I can have. With > this approach, I need to have two tables for B. As a result, all queries, > insertion, update, deletion, of B need to operate on thes

Re: [SQL] Query problem

On Tue, Aug 19, 2003 at 15:02:24 +0200, Rado Petrik <[EMAIL PROTECTED]> wrote: > > In programing language output = > > id(1..3) { > $output = ( bit | $output ); > } > > How write query ? . Thanks You probably want to write a custom aggregate function to do this.

Re: [SQL] postgres 7.1.3: why does the query plan ignore indexes?

[EMAIL PROTECTED] wrote: > > Marco Vezzoli <[EMAIL PROTECTED]> writes: > > ewsweb_test=> \d measures_product > > Index "measures_product" > > Attribute | Type > > +-- > > product_id | smallint > > > > ewsweb_test=> explain select zero_yield, gross

Re: [SQL] postgres 7.1.3: why does the query plan ignore indexes?

Marco Vezzoli <[EMAIL PROTECTED]> writes: > ewsweb_test=> \d measures_product > Index "measures_product" > Attribute | Type > +-- > product_id | smallint > ewsweb_test=> explain select zero_yield, gross from measures where > product_id=29 and da

[SQL] Query problem

Hi, I have table "user". table "user" id bit(dec)bit(bin) - 1 1 1 2 311 3 12 1100 and I need query - > SELECT "output" FROM user WHERE id = 1 OR id = 2 or id = 3 output = () In programing lan

Re: [SQL] Migration from db2 to postgres'

> I wanted to know how can I migrate all my data > including the schema and their definitions,from > IBM's db2 to the postgres. > I have done this with other DBMSs before by writing a program (using PowerBuilder). The core concept is this: two ODBC datasources (source, target) for (loop throug

[SQL] Migration from db2 to postgres'

August 19th 2003 4:36p Dear All, I wanted to know how can I migrate all my data including the schema and their definitions,from IBM's db2 to the postgres. Have a grate day -Warm RegardsShÿam PeriII Floor, Punja Building,M.G.Road,Ballalbagh,Mangalore-575003 Ph : 91-824-2451001/5Fax : 91-

[SQL] postgres 7.1.3: why does the query plan ignore indexes?

Hi, I know this question was asked many times, but please help me understand what I am doing wrong. I work with a postgresql 7.1.3 on Solaris 8 compiled with gcc 3.0.2 Some indexes are defined on a table ewsweb_test=> \d measures_product Index "measures_product" Attribute | Type -

Re: [SQL] Changing data type must recreate all views?

Yudie writes: > I need to change column data type from integer to float8 > That mean to droping table and recreate a new one and can lost the original > object id. > Do i need to recreate all views and triggers that relate to that table? > if that so, is there anyway to do that without touching vi