[GENERAL] News from IBM (DB2)

2006-02-02 Thread Nicolay A Vasiliev
Hello there! http://news.zdnet.co.uk/software/0,39020381,39249666,00.htm What do you think about this? Nicolay ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] PL language selection

2005-11-10 Thread Nicolay A Vasiliev
Thanks! Nice link! Tino Wildenhain wrote: as such, dont miss http://python.projects.postgresql.org/ which is a new approach for pl/python (among other things it does too) It allows you, with PG 8.x, to write set returning functions which are lazy (e.g. built values as they are fetched) - via s

Re: [GENERAL] PL language selection

2005-11-10 Thread Nicolay A Vasiliev
Martijn van Oosterhout wrote: On Thu, Nov 10, 2005 at 12:16:12PM +0300, Nicolay A Vasiliev wrote: There are a number of different PL-languages. How do you select these languages? I think PL/SQL is more fast or am I wrong? Suggest me please your way of PL language selection. Well, it kind

Re: [GENERAL] PL language selection

2005-11-10 Thread Nicolay A Vasiliev
Richard Huxton wrote: Nicolay A Vasiliev wrote: Hello! I am going to be inspired into PostgreSQL community. So I need your advices, buddies. Crikey! I must be more persuasive than I thought :-) Wow :) There are a number of different PL-languages. How do you select these languages? I

Re: [GENERAL] Dynamic web sites with PostgreSQL

2005-11-10 Thread Nicolay A Vasiliev
Hello, Richard, and thanks for your answer! Best of all, sorry for my poor English cause I am not a native English speaking man :( . Richard Huxton wrote: > Nicolay A Vasiliev wrote: > >> Hello there! >> >> I'd like to ask the PostgreSQL community for the cons

[GENERAL] PL language selection

2005-11-10 Thread Nicolay A Vasiliev
Hello! I am going to be inspired into PostgreSQL community. So I need your advices, buddies. There are a number of different PL-languages. How do you select these languages? I think PL/SQL is more fast or am I wrong? Suggest me please your way of PL language selection. Thanks in advance, N

Re: [GENERAL] script

2005-11-10 Thread Nicolay A Vasiliev
Hello! How do you get the list of id's? If you get it while some calculating you may get the list of them (1, 3, 6,...) and then produce the query select * from tablename where id in (your_list) Hope this helps, Nicolay Maik Trömel wrote: Hello! I want to run a shell script with variables

[GENERAL] Dynamic web sites with PostgreSQL

2005-11-10 Thread Nicolay A Vasiliev
Hello there! I'd like to ask the PostgreSQL community for the conseptual thing. We develop our web sites using MySQL. We like this for its high speed and fulltext search feature. But nowadays our projects are growing fast and we afraid our MySQL won't be able to perform large amount of complex