代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/183001/5258811
sql date.sql
-- date check
CREATE TABLE datetmp (a date);
\copy datetmp from 'data/date.data'
SET enable_seqscan=on;
SELECT count(*) FROM datetmp WHERE a < '2001-02-13';
SELECT count(*) FROM datetmp WHERE a
www.eeworm.com/read/183001/5258812
sql time.sql
-- time check
CREATE TABLE timetmp (a time);
\copy timetmp from 'data/time.data'
SET enable_seqscan=on;
SELECT count(*) FROM timetmp WHERE a < '10:57:11';
SELECT count(*) FROM timetmp WHERE a
www.eeworm.com/read/183001/5258813
sql bit.sql
-- bit check
CREATE TABLE bittmp (a bit(33));
\copy bittmp from 'data/bit.data'
SET enable_seqscan=on;
SELECT count(*) FROM bittmp WHERE a < '011011000100010111011000110000100';
SELECT count(*)
www.eeworm.com/read/183001/5258814
sql oid.sql
-- oid check
SET enable_seqscan=on;
SELECT count(*) FROM moneytmp WHERE oid < ( SELECT oid FROM moneytmp WHERE a = '22649.64' );
SELECT count(*) FROM moneytmp WHERE oid
www.eeworm.com/read/183001/5258815
sql text.sql
-- text check
CREATE TABLE texttmp (a text);
\copy texttmp from 'data/text.data'
\copy texttmp from 'data/char.data'
SET enable_seqscan=on;
SELECT count(*) FROM texttmp WHERE a < '31b0';
SELECT
www.eeworm.com/read/183001/5258816
sql timestamp.sql
-- timestamp check
CREATE TABLE timestamptmp (a timestamp);
\copy timestamptmp from 'data/timestamp.data'
SET enable_seqscan=on;
SELECT count(*) FROM timestamptmp WHERE a < '2004-10-26 08:55:08';
www.eeworm.com/read/183001/5258817
sql timetz.sql
-- timetz check
CREATE TABLE timetztmp (a timetz);
\copy timetztmp from 'data/timetz.data'
CREATE TABLE timetzcmp ( r_id int2, a int4, b int4 );
SET enable_seqscan=on;
INSERT INTO timetzcmp (r_id
www.eeworm.com/read/183001/5258821
sql cidr.sql
-- cidr check
CREATE TABLE cidrtmp AS
SELECT cidr(a) AS a FROM inettmp ;
SET enable_seqscan=on;
SELECT count(*) FROM cidrtmp WHERE a < '121.111.63.82';
SELECT count(*) FROM cidrtmp WHERE a
www.eeworm.com/read/183001/5258823
sql varchar.sql
-- char check
CREATE TABLE vchartmp (a varchar(32));
\copy vchartmp from 'data/char.data'
SET enable_seqscan=on;
SELECT count(*) FROM vchartmp WHERE a < '31b0'::varchar(32);
SELECT count(*) FRO
www.eeworm.com/read/183001/5258824
sql numeric.sql
-- numeric check
CREATE TABLE numerictmp (a numeric);
\copy numerictmp from 'data/int8.data'
\copy numerictmp from 'data/numeric.data'
\copy numerictmp from 'data/float8.data'
SET enable_seqscan=on