From: | davidb(at)vectormath(dot)com |
---|---|
To: | "gomathir" <gomathir(at)technauts(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Suggest a query |
Date: | 2000-05-31 15:27:42 |
Message-ID: | 007701bfcb15$99c5c4d0$0602010a@bullwinkle.vectormath |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi Gomathi,
I could be wrong . . . But I am pretty sure you are going to have to do
this
programmatically. PHP is what we use for things like this.
David Boerwinkle
-----Original Message-----
From: gomathir <gomathir(at)technauts(dot)com>
To: pgsql-novice(at)postgresql(dot)org <pgsql-novice(at)postgresql(dot)org>
Date: Tuesday, May 30, 2000 2:56 PM
Subject: [NOVICE] Suggest a query
>Hi friends,
>
>I have a table in my postgre data base. In that table I have a field
>called folder_name whose value will be full path of the mailbox . For
>example /gomathi/ax/ay/mbox is the value of folder_name,
>where mbox is the mail box. I want to find out all the mail boxes
>whose parent is mbox.
>
>Actually I can try as
>
>Select folder_name from mail_box where folder_name like 'mbox/%' ;
>
>
>but I should not hard code the folder_name as given above after
>'like'. SInce folder_name comes as a parameter to the program the
>value cannot be hardcoded.
>Please suggest an alternative way to find out the sub folders of folder
>mbox.
>
>
>Regards,
>gomathi
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | davidb | 2000-05-31 15:41:17 | Fw: change column after creation? |
Previous Message | davidb | 2000-05-31 15:18:32 | Re: change column after creation? |