diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-03-21 16:02:16 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-03-21 16:02:16 +0000 |
| commit | 95ef6a344821655ce4d0a74999ac49dd6af6d342 (patch) | |
| tree | df484a4c9dde9827894ab707917c001a1f376749 /src/test/regress/input/misc.source | |
| parent | 8c9c8ca2b57e4edef218245ccdc9eef7c06425d8 (diff) | |
| download | postgresql-95ef6a344821655ce4d0a74999ac49dd6af6d342.tar.gz | |
First phase of SCHEMA changes, concentrating on fixing the grammar and
the parsetree representation. As yet we don't *do* anything with schema
names, just drop 'em on the floor; but you can enter schema-compatible
command syntax, and there's even a primitive CREATE SCHEMA command.
No doc updates yet, except to note that you can now extract a field
from a function-returning-row's result with (foo(...)).fieldname.
Diffstat (limited to 'src/test/regress/input/misc.source')
| -rw-r--r-- | src/test/regress/input/misc.source | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/src/test/regress/input/misc.source b/src/test/regress/input/misc.source index 9c7a707f1c..18bf4e8af7 100644 --- a/src/test/regress/input/misc.source +++ b/src/test/regress/input/misc.source @@ -170,44 +170,44 @@ SELECT class, aa, a FROM a_star*; -- joe and sally play basketball, and -- everyone else does nothing. -- -SELECT p.name, p.hobbies.name FROM ONLY person p; +SELECT p.name, name(p.hobbies) FROM ONLY person p; -- -- as above, but jeff also does post_hacking. -- -SELECT p.name, p.hobbies.name FROM person* p; +SELECT p.name, name(p.hobbies) FROM person* p; -- -- the next two queries demonstrate how functions generate bogus duplicates. -- this is a "feature" .. -- -SELECT DISTINCT hobbies_r.name, hobbies_r.equipment.name FROM hobbies_r; +SELECT DISTINCT hobbies_r.name, name(hobbies_r.equipment) FROM hobbies_r; -SELECT hobbies_r.name, hobbies_r.equipment.name FROM hobbies_r; +SELECT hobbies_r.name, (hobbies_r.equipment).name FROM hobbies_r; -- -- mike needs advil and peet's coffee, -- joe and sally need hightops, and -- everyone else is fine. -- -SELECT p.name, p.hobbies.name, p.hobbies.equipment.name FROM ONLY person p; +SELECT p.name, name(p.hobbies), name(equipment(p.hobbies)) FROM ONLY person p; -- -- as above, but jeff needs advil and peet's coffee as well. -- -SELECT p.name, p.hobbies.name, p.hobbies.equipment.name FROM person* p; +SELECT p.name, name(p.hobbies), name(equipment(p.hobbies)) FROM person* p; -- -- just like the last two, but make sure that the target list fixup and -- unflattening is being done correctly. -- -SELECT p.hobbies.equipment.name, p.name, p.hobbies.name FROM ONLY person p; +SELECT name(equipment(p.hobbies)), p.name, name(p.hobbies) FROM ONLY person p; -SELECT p.hobbies.equipment.name, p.name, p.hobbies.name FROM person* p; +SELECT (p.hobbies).equipment.name, p.name, name(p.hobbies) FROM person* p; -SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM ONLY person p; +SELECT (p.hobbies).equipment.name, name(p.hobbies), p.name FROM ONLY person p; -SELECT p.hobbies.equipment.name, p.hobbies.name, p.name FROM person* p; +SELECT name(equipment(p.hobbies)), name(p.hobbies), p.name FROM person* p; SELECT user_relns() AS user_relns ORDER BY user_relns; |
