Hi,
Try looking at the contrib/tablefunc add-in module.
Chris
Kamalraj Singh Madhan wrote:
> Hi Friends,
> Does anybody know the substitute of the oracle function 'connect by
> prior' in postgre sql.
> The query is basically being used to get a tree structure of records. The
> query in oracle is :-
>
> select pkmsgid
> from mstmessage
> connect by prior pkmsgid = msgparentid
> start with msgparentid = 1
>
> Kindly suggest.
>
> regards
> Kamal
>
>
>
> *********************************************************************
> Network Programs is a SEI CMM Level 5 Certified Company
> ********************************************************************
> The information contained in this communication (including any attachments) is
> intended solely for the use of the individual or entity to whom it is addressed
> and others authorized to receive it. It may contain confidential or legally
> privileged information. If you are not the intended recipient you are hereby
> notified that any disclosure, copying, distribution or taking any action in
> reliance on the contents of this information is strictly prohibited and may be
> unlawful. If you have received this communication in error, please notify us
> immediately by responding to this email and then delete it from your system.
> Network Programs (India) Limited is neither liable for the proper and complete
> transmission of the information contained in this communication nor for any
> delay in its receipt.
> *********************************************************************
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org