pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: David BOURIAUD <david.bouriaud@ac-rouen.fr>
To: pgsql-sql@postgresql.org
Subject: Problem with pg_index.
Date: Fri, 01 Jun 2001 15:52:31 +0200
Message-ID: <3B179E1F.4F9D8A4B@ac-rouen.fr> (raw)

Hi the list !
I'm new to this list.
I've tried to write a sql query to get all the fields of a table and to
have mentionned is a field can be null or not, and if a field is a key
or not.
Before showing the query I send, let me tell you that I'm running
postgre v7.1.2 on a SuSE Linux 6.4 box, and that everything works fine
but this query.
Here it is :

select 
	pg_class.oid, 
	pg_attribute.attname, 
	pg_attribute.attbyval, 
	pg_attribute.attnotnull 
from 
	pg_class, 
	pg_attribute, 
	pg_index 
where 
	relname='essai2'
	and pg_attribute.attrelid=pg_class.oid 
	and pg_attribute.attnum >0 
	and pg_index.indrelid=pg_class.oid 
	and pg_index.indkey[0] = pg_attribute.attnum 

This query doesn't work, the back-end answers Error : Invalid Command
name "0"...
What now ? I've checked out the online doc, and the archives of this
list (that's where I got pg_index.indkey[0] from), but nothing seems to
work, since pg_index.indkey seems to be an int2vector, and I found no
integrated function to check if a value is in this vector... Thanks for
your ideas and//or help.
-- 
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have 
for windows or gates ?
----------------------------------------------------------
ICQ#102562021



view thread (2+ messages)  latest in thread

Message-ID: <3B179E1F.4F9D8A4B@ac-rouen.fr>
Permalink:  ../3B179E1F.4F9D8A4B@ac-rouen.fr/
Also on:    postgresql.org/message-id/3B179E1F.4F9D8A4B@ac-rouen.fr

 · 

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: pgsql-sql@postgresql.org
  Cc: david.bouriaud@ac-rouen.fr
  Subject: Re: Problem with pg_index.
  In-Reply-To: <3B179E1F.4F9D8A4B@ac-rouen.fr>

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

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