← Back to branch summary

~ubuntu-branches/ubuntu/lucid/postgresql-8.4/lucid-proposed

« back to all changes in this revision

Viewing changes to src/backend/catalog/information_schema.sql

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2009-07-11 16:59:35 UTC
  • mfrom: (5.1.1 karmic)
  • Revision ID: james.westby@ubuntu.com-20090711165935-jfwin6gfrxf0gfsi
Tags: 8.4.0-2
http://bugs.debian.org/536139
* debian/libpq-dev.install: Ship catalog/genbki.h. (Closes: #536139)
* debian/rules: Drop --enable-cassert for final release.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/backend/catalog/information_schema.sql
4
4
 *
5
5
 * Copyright (c) 2003-2009, PostgreSQL Global Development Group
6
6
 *
7
 
 * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.53 2009/02/24 10:06:32 petere Exp $
 
7
 * $PostgreSQL: pgsql/src/backend/catalog/information_schema.sql,v 1.54 2009/06/10 07:03:34 petere Exp $
8
8
 */
9
9
 
10
10
/*
160
160
    RETURNS NULL ON NULL INPUT
161
161
    AS
162
162
$$SELECT
163
 
  CASE WHEN $2 = -1 /* default typmod */
164
 
       THEN null
 
163
  CASE WHEN $1 IN (1082) /* date */
 
164
           THEN 0
165
165
       WHEN $1 IN (1083, 1114, 1184, 1266) /* time, timestamp, same + tz */
166
 
       THEN $2
 
166
           THEN CASE WHEN $2 < 0 THEN 6 ELSE $2 END
167
167
       WHEN $1 IN (1186) /* interval */
168
 
       THEN $2 & 65535
 
168
           THEN CASE WHEN $2 < 0 THEN 6 ELSE $2 & 65535 END
169
169
       ELSE null
170
170
  END$$;
171
171