Skip site navigation (1) Skip section navigation (2)

Re: Is there anyway to get list of table name, before raw parser is analyze?

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Mohammad Heykal Abdillah <heykal(dot)abdillah(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is there anyway to get list of table name, before raw parser is analyze?
Date: 2010-05-30 04:44:22
Message-ID: 4C01ED26.9070307@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

Mohammad Heykal Abdillah wrote:
> Hi all,
>
> Right now i am trying to understand how SQL parser is work. 
>
> My question is there anyway to get list of table name and its atribut
> before raw parser is analyze?
>
> Because i like to understand how PostgreSQL "break-down" the asterik at
> target list, specialy in "natural join" case where PostgreSQL can give
> query result that have unabigous attribut and match the right join key.
>
>
>   

AIUI, expanding '*' is not done in the parser. The parser just makes an 
A_star node.

See src/backend/gram.y for the parser spec.

Maybe you need to explain what exactly you're trying to do.

cheers

andrew

In response to

Responses

pgsql-hackers by date

Next:From: Mohammad Heykal AbdillahDate: 2010-05-30 05:43:25
Subject: Re: Is there anyway to get list of table name, before raw parser is analyze?
Previous:From: Robert HaasDate: 2010-05-30 03:55:02
Subject: Re: small exclusion constraints patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group