高级数据库_lesson8.pptVIP

高级数据库 第八讲 String functions Operators Regular expression 谭舜泉 信息工程学院 SQL String Functions and Operators string || string (String concatenation ) Post || greSQL = PostgreSQL string || non-string or non-string || string Value: || 42 = Value: 42 bit_length(string) (Number of bits in string) bit_length(jose) = 32 char_length(string) or character_length(string) char_length(jose) = 4 SQL String Functions and Operators lower(string) (Convert string to lower case ) lower(TOM) = tom overlay(string placing string from int [for int]) (Replace substring ) overlay(Txxxxas placing hom from 2 for