Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id RAA14475 for postgres-redist; Fri, 24 Jun 1994 17:43:22 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199406250043.RAA14475@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from cs.mtu.edu (cs.mtu.edu [141.219.150.12]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id RAA14464 for ; Fri, 24 Jun 1994 17:43:20 -0700 Received: from werner.mtu.edu (werner.cs.mtu.edu) by cs.mtu.edu (4.1/SMI-4.1) id AA11587; Fri, 24 Jun 94 20:43:19 EDT From: aataneja@cs.mtu.edu (Bruce Taneja.) Message-Id: <9406250043.AA11587@cs.mtu.edu> Subject: attribute names in "retrieve.." To: postgres@postgres.Berkeley.EDU Date: Fri, 24 Jun 1994 20:43:20 -0400 (EDT) X-Mailer: ELM [version 2.4 PL22] Content-Type: text Content-Length: 1517 Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Fri, 24 Jun 94 17:43:21 -0700 Resent-XMts: smtp Howdy folks, I am trying to define a "complex object" .. for simplicity assume the circle.c example .. * retrieve (tutorial.all) \g would produce something like : Query sent to backend is "retrieve (tutorial.all) " --------------- | a c | --------------- | (1 , 1, 10) | --------------- | (2 , 2, 5) | --------------- | (0 , 1.8, 10)| --------------- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Now, what I NEED is : ----------------------------------- | circle a | ----------------------------------- |center x | center y | radius | ----------------------------------- | 1 | 1 | 10 | ----------------------------------- | 2 | 2 | 5 | ----------------------------------- | 0 | 1.8 | 10 | ----------------------------------- I can see how to produce "fancy string" data like: " | 1 | 1 | 10 | " from my "circle_out " function , but how do can force postgres to create a fancy header like I want : ----------------------------------- | circle a | ----------------------------------- and not just ---------- |center x | center y | radius | | a | ----------------------------------- ---------- ..... I don't think I can do this from the circle_out function as then this header would be attached to every tuple retrieved .. so where do I have to do the hacking ???? thanks a lot ! Bruce! ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU" If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ==============================================================================