Re: [SQL] We all are looped on Internet: request +transport = invariant

2007-04-22 Thread Bart Degryse
A hierarchical is specialized in managing data which is hierarchically structured, while a relational database is not. Maybe this analogy is clearer: If you want to fly you could attach wings to your sportscar, but it's more logical to use a plane. >>> Dmitry Turin <[EMAIL PROTECTED]> 2007-04-20 1

Re: [SQL] Windows postgres

2007-04-22 Thread Paul Lambert
Senthil wrote: Respected sir/madam, Please can you send me link of windows postgres sql download page. thanks senthil ---(end of broadcast)--- TIP 6: explain analyze is your friend http://www.postgresql.org/ftp/binary/v8.2.4/win32/ -- Paul

[SQL] Regular Expression Data Type

2007-04-22 Thread Richard Doust
Hi. I appreciate that I can query the database and find records that match a regular expression. What I'd like to be able to do is to define a field in the database as a regular expression so that when I select, i.e., select price from shipping_prices where shipFromZip = '23773' and shipTo

[SQL] i have prolem can you help me

2007-04-22 Thread saytinh
-- Table: ticket -- DROP TABLE ticket; CREATE TABLE ticket ( gid serial NOT NULL, id integer, name character varying, address character varying(254), province character varying(100), fax character varying(50), code integer, "type" integer, phone character varying(15), web cha

[SQL] Windows postgres

2007-04-22 Thread Senthil
Respected sir/madam, Please can you send me link of windows postgres sql download page. thanks senthil ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [SQL] Floating point type to store numbers

2007-04-22 Thread Lew
Andrew Sullivan wrote: On Tue, Apr 17, 2007 at 04:33:33PM -0400, Radhika Sambamurti wrote: Andrew, This has been quite helpful. My main concern is CPU cost. Thanks for the input. You're welcome. Are you sure your main concern should be CPU cost? It's true that numeric is more costly that flo

[SQL] Retrieve month from date in SQl query

2007-04-22 Thread RPK
I am using PGSQL 8.2.3 on Windows XP. I have a table called "StudentFeesPayment" with columns "ReceiptNo" and "ReceiptMonthYear". The column, "ReceiptMonthYear" stores date in the format "-mm-dd". I have to find the max(ReceiptNo) where Month of (ReceiptMonthYear)=4. Or whatever month I give.