Parent Directory | Revision Log | Patch
revision 27 by dpavlin, Sat Jul 23 19:21:07 2005 UTC | revision 28 by dpavlin, Sun Jul 24 09:27:26 2005 UTC | |
---|---|---|
# | Line 84 create table items_pgbits ( | Line 84 create table items_pgbits ( |
84 | ||
85 | create view pgbits_articles as select | create view pgbits_articles as select |
86 | issue, | issue, |
87 | entries_pgbits.date as issue_date, | date(entries_pgbits.date) as issue_date, |
88 | ititle, | ititle, |
89 | mytitle, | mytitle, |
90 | items_pgbits.date as date | date(items_pgbits.date) as date |
91 | from items_pgbits | from items_pgbits |
92 | join entries_pgbits on entry_id = entries_pgbits.id ; | join entries_pgbits on entry_id = entries_pgbits.id ; |
93 |
|
ViewVC Help | |
Powered by ViewVC 1.1.26 |