代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/183001/5258825
sql interval.sql
-- interval check
CREATE TABLE intervaltmp (a interval);
\copy intervaltmp from 'data/interval.data'
SET enable_seqscan=on;
SELECT count(*) FROM intervaltmp WHERE a < '199 days 21:21:23';
SELECT
www.eeworm.com/read/183001/5258826
sql timestamptz.sql
-- timestamptz check
CREATE TABLE timestamptztmp (a timestamptz);
\copy timestamptztmp from 'data/timestamptz.data'
SET enable_seqscan=on;
SELECT count(*) FROM timestamptztmp WHERE a < '2018-12-1
www.eeworm.com/read/183001/5258827
sql macaddr.sql
-- macaddr check
CREATE TABLE macaddrtmp (a macaddr);
\copy macaddrtmp from 'data/macaddr.data'
SET enable_seqscan=on;
SELECT count(*) FROM macaddrtmp WHERE a < '22:00:5c:e5:9b:0d';
SELECT count
www.eeworm.com/read/183001/5258828
sql example.sql
-- Note the syntax is strict because i have no time to write better perl filter.
--
-- [blank] is 1 blank
-- at the end of an interesting line must be a [,] or [--]
-- [ending] must be a , or --
www.eeworm.com/read/183001/5258838
sql dblink.sql
-- Adjust this setting to control where the objects get created.
SET search_path = public;
--
-- Define the functions and test data
-- therein.
--
-- Turn off echoing so that expected file does not d
www.eeworm.com/read/183001/5258864
sql init.sql
--
-- init pgcrypto
--
\set ECHO none
\i pgcrypto.sql
\set ECHO all
-- check for encoding fn's
SELECT encode('foo', 'hex');
SELECT decode('666f6f', 'hex');
-- check error handling
select gen_salt('
www.eeworm.com/read/183001/5258867
sql rijndael.sql
--
-- AES / Rijndael-128 cipher
--
-- some standard Rijndael testvalues
SELECT encode(encrypt(
decode('00112233445566778899aabbccddeeff', 'hex'),
decode('000102030405060708090a0b0c0d0e0f', 'hex'),
'a
www.eeworm.com/read/183001/5258883
sql des.sql
--
-- DES cipher
--
-- no official test vectors atm
-- from blowfish.sql
SELECT encode(encrypt(
decode('0123456789abcdef', 'hex'),
decode('fedcba9876543210', 'hex'),
'des-ecb/pad:none'), 'hex');
--
www.eeworm.com/read/183001/5258887
sql blowfish.sql
--
-- Blowfish cipher
--
-- some standard Blowfish testvalues
SELECT encode(encrypt(
decode('0000000000000000', 'hex'),
decode('0000000000000000', 'hex'),
'bf-ecb/pad:none'), 'hex');
SELECT encode(e
www.eeworm.com/read/183001/5258893
sql _int.sql
--
-- first, define the datatype. Turn off echoing so that expected file
-- does not depend on contents of _int.sql.
--
\set ECHO none
\i _int.sql
\set ECHO all
SELECT intset(1234);
SELECT icount('{