Re: [SQL] cost of CREATE VIEW ... AS SELECT DISTINCT

On Mon, 2005-03-28 at 15:43, T E Schmitz wrote: > Hello, > How expensive would it be to maintain the following VIEW: > > CREATE VIEW origin AS SELECT DISTINCT origin FROM transaktion > > if there is in index on transaktion.origin; the table transaktion has > thousands of records and there are on

[SQL] cost of CREATE VIEW ... AS SELECT DISTINCT

Hello, How expensive would it be to maintain the following VIEW: CREATE VIEW origin AS SELECT DISTINCT origin FROM transaktion if there is in index on transaktion.origin; the table transaktion has thousands of records and there are only a few distinct origin? -- Regards/Gruß, Tarlika Elisabeth Sc

Re: [SQL] Postgres 7.3 migrate to 8.0 date problems.

On Mon, 2005-03-28 at 13:44, Thomas Seeber wrote: > Hi, > > We were upgrading from postgres 7.3 -> 8.0 and having a little > problems importing dates from some of our data sources. Say we have a > date like '2004-17-05'. In postgres 7.3, postgres would intrept this > as Year Day Month automatica

[SQL] Postgres 7.3 migrate to 8.0 date problems.

Hi, We were upgrading from postgres 7.3 -> 8.0 and having a little problems importing dates from some of our data sources. Say we have a date like '2004-17-05'. In postgres 7.3, postgres would intrept this as Year Day Month automatically. In the documentation, from postgres 7.4 on this has to b

Re: [SQL] connectby queries

On Mon, Mar 28, 2005 at 02:02:32PM +0530, Chandan_Kumaraiah wrote: > > How do I write hierarchical queries in postgresql, which I would write > using 'connectby' in oracle?? The contrib/tablefunc module has a connectby() function -- does it do what you want? -- Michael Fuhr http://www.fuhr.org/~

Re: [SQL] [HACKERS] Executing Anonymous Blocks

On Mon, Mar 28, 2005 at 12:27:18PM +0500, imad wrote: > I want to know is there any way to execute an anonymous PL/pgSQL block > in PostgreSQL. No, there isn't. -- Alvaro Herrera (<[EMAIL PROTECTED]>) Al principio era UNIX, y UNIX habló y dijo: "Hello world\n". No dijo "Hello New Jersey\n", ni

Re: [SQL] (non)zero function

Hi, On Sun, 27 Mar 2005, Enrico Weigelt wrote: Hi folks, is there an function returning true if the argument is null or zero (just to make some queries more concise). Of course its trivial to implement as SQL function, but if postgresql already provides such a function, I would prefer using it. Loo

[SQL] connectby queries

Hi,   How do I write hierarchical queries in postgresql, which I would write using ‘connectby’ in oracle??   Thanx in adv Chandan