From: | gomathir <gomathir(at)technauts(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Suggest a query |
Date: | 2000-05-30 18:28:48 |
Message-ID: | 3934085F.EDE47588@technauts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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 | James M . Burton | 2000-05-30 22:13:02 | change column after creation? |
Previous Message | Robert B. Easter | 2000-05-30 13:10:27 | Re: Unlinking large objects |