agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Bruce Taneja. <aataneja@cs.mtu.edu>
To: postgres@postgres.Berkeley.EDU
Subject: attribute names in "retrieve.."
Date: Fri, 24 Jun 1994 20:43:20 -0400 (EDT)
Message-ID: <9406250043.AA11587@cs.mtu.edu> (raw)


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.
==============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: aataneja@cs.mtu.edu
  Subject: Re: attribute names in "retrieve.."
  In-Reply-To: <9406250043.AA11587@cs.mtu.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox