Re: [SQL] new idea

2007-04-09 Thread Andrew Sullivan
On Mon, Apr 09, 2007 at 09:42:24AM +0300, sql4-en.narod.ru wrote: > Let me know your opinion about next way of processing and extracting data. > This would very comfortable for delivery xml-data into any program, for > example into browser. > Has this idea future ? What are you think ? What does

Re: [SQL] new idea

2007-04-09 Thread Erik Jones
On Apr 9, 2007, at 7:21 AM, Andrew Sullivan wrote: On Mon, Apr 09, 2007 at 09:42:24AM +0300, sql4-en.narod.ru wrote: Let me know your opinion about next way of processing and extracting data. This would very comfortable for delivery xml-data into any program, for example into browser. Has

Re: [SQL] new idea

2007-04-09 Thread Andrew Sullivan
On Mon, Apr 09, 2007 at 09:11:57AM -0500, Erik Jones wrote: > > I don't really even see the need for inheritance here. This is what > most ORMs do at the application level already. Wel, sure, but the poster seemed to think that having a way to represent this in the database was a good thing.

Re: [SQL] [ADMIN] Another question in functions

2007-04-09 Thread Stephan Szabo
On Sun, 8 Apr 2007, Karthikeyan Sundaram wrote: > > Hi team, > > I have a requirement like this. > create table valid_lovs (code_id int not null,lov_value int not null > ,description varchar(256),status bit(1) not null default '1',constraint > lov_pk primary key (code_id,lov_value)); > I n

Re: [SQL] MD5 sums of large objects

2007-04-09 Thread Dirk Jagdmann
Hello Michael, thanks for the comments on my corrected function. You could make a proposal in pgsql-hackers but I think 8.3 is in feature freeze so don't expect to see it until 8.4, if it's accepted at all. There's always PgFoundry :-) I'll now see how this performs in my application and if

Re: [SQL] new idea

2007-04-09 Thread Erik Jones
On Apr 9, 2007, at 9:14 AM, Andrew Sullivan wrote: On Mon, Apr 09, 2007 at 09:11:57AM -0500, Erik Jones wrote: I don't really even see the need for inheritance here. This is what most ORMs do at the application level already. Wel, sure, but the poster seemed to think that having a way to r