代码搜索:OUT
找到约 10,000 项符合「OUT」的源代码
代码结果 10,000
www.eeworm.com/read/376006/2718014
out interval.out
--
-- INTERVAL
--
SET DATESTYLE = 'ISO';
-- check acceptance of "time zone style"
SELECT INTERVAL '01:00' AS "One hour";
One hour
----------
01:00:00
(1 row)
SELECT INTERVAL '+02:00' AS "Two hours
www.eeworm.com/read/376006/2718015
out dependency.out
--
-- DEPENDENCIES
--
CREATE USER regression_user;
CREATE USER regression_user2;
CREATE USER regression_user3;
CREATE GROUP regression_group;
CREATE TABLE deptest (f1 serial primary key, f2 text);
NOT
www.eeworm.com/read/376006/2718016
out select_into.out
--
-- SELECT_INTO
--
SELECT *
INTO TABLE tmp1
FROM onek
WHERE onek.unique1 < 2;
DROP TABLE tmp1;
SELECT *
INTO TABLE tmp1
FROM onek2
WHERE onek2.unique1 < 2;
DROP TABLE tmp1;
www.eeworm.com/read/376006/2718019
out char.out
--
-- CHAR
--
-- fixed-length by value
-- internally passed by value if
www.eeworm.com/read/376006/2718022
out circle.out
--
-- CIRCLE
--
CREATE TABLE CIRCLE_TBL (f1 circle);
INSERT INTO CIRCLE_TBL VALUES ('');
INSERT INTO CIRCLE_TBL VALUES ('');
INSERT INTO CIRCLE_TBL VALUES ('1,3,5');
INSERT INTO CI
www.eeworm.com/read/376006/2718026
out strings.out
--
-- STRINGS
-- Test various data entry syntaxes.
--
-- SQL92 string continuation syntax
-- E021-03 character string literals
SELECT 'first line'
' - next line'
' - third line'
AS "Three lines to o
www.eeworm.com/read/376006/2718027
out privileges.out
--
-- Test access privileges
--
-- Clean up in case a prior regression run failed
-- Suppress NOTICE messages when users/groups don't exist
SET client_min_messages TO 'error';
DROP ROLE IF EXISTS regr
www.eeworm.com/read/376006/2718028
out inet.out
--
-- INET
--
-- prepare the table...
DROP TABLE INET_TBL;
ERROR: table "inet_tbl" does not exist
CREATE TABLE INET_TBL (c cidr, i inet);
INSERT INTO INET_TBL (c, i) VALUES ('192.168.1', '192.168.1.2
www.eeworm.com/read/376006/2718030
out subselect.out
--
-- SUBSELECT
--
SELECT 1 AS one WHERE 1 IN (SELECT 1);
one
-----
1
(1 row)
SELECT 1 AS zero WHERE 1 NOT IN (SELECT 1);
zero
------
(0 rows)
SELECT 1 AS zero WHERE 1 IN (SELECT 2);
zero
-