<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/postgresql.git/src/include/parser/parse_clause.h, branch REL7_0_PATCHES</title>
<subtitle>git.postgresql.org: git/postgresql.git
</subtitle>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/'/>
<entry>
<title>Ye-old pgindent run.  Same 4-space tabs.</title>
<updated>2000-04-12T17:17:23+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>2000-04-12T17:17:23+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/commit/?id=52f77df613cea1803ce86321c37229626d9f213c'/>
<id>52f77df613cea1803ce86321c37229626d9f213c</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Carry column aliases from the parser frontend. Enables queries like</title>
<updated>2000-02-15T03:38:29+00:00</updated>
<author>
<name>Thomas G. Lockhart</name>
<email>lockhart@fourpalms.org</email>
</author>
<published>2000-02-15T03:38:29+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/commit/?id=a344a6e7b5d7b2b87f33a155c3ef88bdfdce3fd8'/>
<id>a344a6e7b5d7b2b87f33a155c3ef88bdfdce3fd8</id>
<content type='text'>
  SELECT a FROM t1 tx (a);
Allow join syntax, including queries like
  SELECT * FROM t1 NATURAL JOIN t2;
Update RTE structure to hold column aliases in an Attr structure.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
  SELECT a FROM t1 tx (a);
Allow join syntax, including queries like
  SELECT * FROM t1 NATURAL JOIN t2;
Update RTE structure to hold column aliases in an Attr structure.
</pre>
</div>
</content>
</entry>
<entry>
<title>Redesign DISTINCT ON as discussed in pgsql-sql 1/25/00: syntax is now</title>
<updated>2000-01-27T18:11:50+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2000-01-27T18:11:50+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/commit/?id=dd979f66be20fc54aad06da743f788fbc505bbe1'/>
<id>dd979f66be20fc54aad06da743f788fbc505bbe1</id>
<content type='text'>
SELECT DISTINCT ON (expr [, expr ...]) targetlist ...
and there is a check to make sure that the user didn't specify an ORDER BY
that's incompatible with the DISTINCT operation.
Reimplement nodeUnique and nodeGroup to use the proper datatype-specific
equality function for each column being compared --- they used to do
bitwise comparisons or convert the data to text strings and strcmp().
(To add insult to injury, they'd look up the conversion functions once
for each tuple...)  Parse/plan representation of DISTINCT is now a list
of SortClause nodes.
initdb forced by querytree change...
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
SELECT DISTINCT ON (expr [, expr ...]) targetlist ...
and there is a check to make sure that the user didn't specify an ORDER BY
that's incompatible with the DISTINCT operation.
Reimplement nodeUnique and nodeGroup to use the proper datatype-specific
equality function for each column being compared --- they used to do
bitwise comparisons or convert the data to text strings and strcmp().
(To add insult to injury, they'd look up the conversion functions once
for each tuple...)  Parse/plan representation of DISTINCT is now a list
of SortClause nodes.
initdb forced by querytree change...
</pre>
</div>
</content>
</entry>
<entry>
<title>Add:</title>
<updated>2000-01-26T05:58:53+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>2000-01-26T05:58:53+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/commit/?id=5c25d60244d3a4b458ba55d4f1e50386edb26507'/>
<id>5c25d60244d3a4b458ba55d4f1e50386edb26507</id>
<content type='text'>
  * Portions Copyright (c) 1996-2000, PostgreSQL, Inc

to all files copyright Regents of Berkeley.  Man, that's a lot of files.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
  * Portions Copyright (c) 1996-2000, PostgreSQL, Inc

to all files copyright Regents of Berkeley.  Man, that's a lot of files.
</pre>
</div>
</content>
</entry>
<entry>
<title>Major revision of sort-node handling: push knowledge of query</title>
<updated>1999-08-21T03:49:17+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>1999-08-21T03:49:17+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/commit/?id=db436adf761bd5cb7990745ceba2959ac4bfca7c'/>
<id>db436adf761bd5cb7990745ceba2959ac4bfca7c</id>
<content type='text'>
sort order down into planner, instead of handling it only at the very top
level of the planner.  This fixes many things.  An explicit sort is now
avoided if there is a cheaper alternative (typically an indexscan) not
only for ORDER BY, but also for the internal sort of GROUP BY.  It works
even when there is no other reason (such as a WHERE condition) to consider
the indexscan.  It works for indexes on functions.  It works for indexes
on functions, backwards.  It's just so cool...

CAUTION: I have changed the representation of SortClause nodes, therefore
THIS UPDATE BREAKS STORED RULES.  You will need to initdb.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
sort order down into planner, instead of handling it only at the very top
level of the planner.  This fixes many things.  An explicit sort is now
avoided if there is a cheaper alternative (typically an indexscan) not
only for ORDER BY, but also for the internal sort of GROUP BY.  It works
even when there is no other reason (such as a WHERE condition) to consider
the indexscan.  It works for indexes on functions.  It works for indexes
on functions, backwards.  It's just so cool...

CAUTION: I have changed the representation of SortClause nodes, therefore
THIS UPDATE BREAKS STORED RULES.  You will need to initdb.
</pre>
</div>
</content>
</entry>
<entry>
<title>Rewrite parser's handling of INSERT ... SELECT so that processing</title>
<updated>1999-07-19T00:26:20+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>1999-07-19T00:26:20+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/commit/?id=7f76eab140e703b7847b107245a669e2010886c0'/>
<id>7f76eab140e703b7847b107245a669e2010886c0</id>
<content type='text'>
of the SELECT part of the statement is just like a plain SELECT.  All
INSERT-specific processing happens after the SELECT parsing is done.
This eliminates many problems, e.g. INSERT ... SELECT ... GROUP BY using
the wrong column labels.  Ensure that DEFAULT clauses are coerced to
the target column type, whether or not stored clause produces the right
type.  Substantial cleanup of parser's array support.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
of the SELECT part of the statement is just like a plain SELECT.  All
INSERT-specific processing happens after the SELECT parsing is done.
This eliminates many problems, e.g. INSERT ... SELECT ... GROUP BY using
the wrong column labels.  Ensure that DEFAULT clauses are coerced to
the target column type, whether or not stored clause produces the right
type.  Substantial cleanup of parser's array support.
</pre>
</div>
</content>
</entry>
<entry>
<title>Change #include's to use &lt;&gt; and "" as appropriate.</title>
<updated>1999-07-15T23:04:24+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>1999-07-15T23:04:24+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/commit/?id=a9591ce66aa69e82196800b0f4f7b6e35aea8e49'/>
<id>a9591ce66aa69e82196800b0f4f7b6e35aea8e49</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Clean up #include in /include directory.  Add scripts for checking includes.</title>
<updated>1999-07-15T15:21:54+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>1999-07-15T15:21:54+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/commit/?id=4b2c2850bf243cfa4a7b4cbd2e60ba1791c098fb'/>
<id>4b2c2850bf243cfa4a7b4cbd2e60ba1791c098fb</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Make functions static or NOT_USED as appropriate.</title>
<updated>1999-05-26T12:57:23+00:00</updated>
<author>
<name>Bruce Momjian</name>
<email>bruce@momjian.us</email>
</author>
<published>1999-05-26T12:57:23+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/commit/?id=278bbf4572996e4097eac0c0d169dea1616ad0b6'/>
<id>278bbf4572996e4097eac0c0d169dea1616ad0b6</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Add parameters to function calls to pass back table qualifications.</title>
<updated>1999-02-23T08:05:27+00:00</updated>
<author>
<name>Thomas G. Lockhart</name>
<email>lockhart@fourpalms.org</email>
</author>
<published>1999-02-23T08:05:27+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/postgresql.git/commit/?id=e17d8448f27a67d78bd9808703a2d8c1fb879cc3'/>
<id>e17d8448f27a67d78bd9808703a2d8c1fb879cc3</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
