Michael Davis ha scritto:
How can I add a comment to a table, function, etc.
that will should up in a
/dd comment in psql?
pg_description has two fields...
joe=> \d pg_description
Table = pg_description
+--+--+---+
|
I'm trying to get the local college to offer a Relational Database Design
class/course. We'd be using PostgreSQL on Linux boxen. I've done some
design and implementation using Oracle and there is a fair amount of books
for this platform but I'm having some trouble finding generic books that
deal
Its been a while since I wrote this and its kinda fuzzy at this hour, but
this will give you a general direction to go and you can work out the
specifics...
If you know the depth of the tree then you can create a field of a specified
length and store something like:
tree_field varchar(16)
A
AA
AB
On Fri, 26 Feb 1999, Kaare Rasmussen wrote:
> I can't figure this one out. I need a tree structure like this
>
> Number Pointer
> 10
> 21
> 31
> 42
> 50
> 61
> 75
>
> This should somehow show up like this
> Num
You could try select spaces(pointer::int4) || Number; Where spaces() is a
function that inserts "pointer" number of spaces (or dashes if you want to
create your own function). Not sure if spaces() exists in Postgres or not,
but it seems I read about it or a similar function somewhere.
I can't figure this one out. I need a tree structure like this
Number Pointer
10
21
31
42
50
61
75
This should somehow show up like this
Number
1
2
4
3
6
5
7
The whole excercise is because I'd like to show a tr
Ummm...no news group exists that I know of...whis there was one. Easier
than this mailing list.
To restrict users from accessing other accounts just make them type in their
old password before you ask for the new... I am not sure if this is the
answer to your question as it is kinda obvious...no
