shape 7 Out[138]: torch.Size([28, 28]) 8 9 In [139]: a[0,0,2,4] 10 Out[139]: tensor(0.8082) ## select first/last N ## ☀️ ☁️ ☁️ 1 In [140]: a.shape 2 Out[140]: torch.Size([4, 3, 28, 328]) 4 In [141]: Size([2, 2, 28, 1228]) 13 In [144]: a[:2, -1:, :].shape 14 Out[144]: torch.Size([2, 1, 28, 28]) ## select by steps ## ☀️ ☁️ ☁️ ☁️ 1 In [145]: a[:,:,0:28:2,0:28:2].shape 2 Out[145]: torch.Size([4, 3, 14 @[1410:2002ch0Si0e2][4shape5, 5]) ## select by specific index ## ☀️ ☁️ ☁️ 1 In [149]: a.shape 2 Out $$ 149 $$ : torch.Size([4, 3, 28, 28]) 3 4 In [159]: a.index_select(0, 5 0ot{h50ens0o({h,S]iæ($hapa

d0b8/p6_1.jpg) 并发编程并不容易，但 Go 对并发有很好的支持 ## Go 语言中的并发 • goroutine - 并发执行 • channel - 同步和消息传输 • select - 多路并发控制 ## Goroutine - 类似于 UNIX 中的 & • 很像线程，但更轻量 - 一个 goroutine 就是一个独立运行的函数 - 当一个 goroutine timerChan 传送值 // 值的发送是另上个 goroutine 结束的时间 completedAt := <-timerChan ## Select • 类似于 switch - 但它的判断条件是基于通信，而不是基于值的等量匹配 select { case v := <-ch1: fmt.Println("channel 1 sends"

добавить комментарий? 239 Примеры 240 6. Операторы DML 241 SELECT 241 FIRST, SKIP 242 Особенности использования 243 Список полей SELECT 244 FROM ..... 248 Выборка из таблицы или представления табличные выражения CTE ("WITH ... AS ... SELECT") ..... 297 Рекурсивные CTE ..... 299 SENT ..... 302 INSERT .. VALUES ..... 303 INSERT .. SELECT ..... 303 INSERT .. DEFAULT VALUES ..... Другие замечания ..... 367 AS USER, PASSWORD и ROLE ..... 367 Предостережения ..... 368 FOR SELECT ..... 368 Необъявленный курсор ..... 369 FOR EXECUTE STATEMENT ..... 372 OPEN ..... 373 FETCH

операторе SELECT при вставке MERGE SELECT Агрегатные функции: Расширенный функционал Использование COLLATE для столбцов с текстовым BLOB Общие табличные выражения (“WITH ... AS ... SELECT”) Производные Производные таблицы (“SELECT FROM SELECT”) FIRST и SKIP GROUP BY HAVING: Более строгие правила JOIN ORDER BY PLAN Использование алиаса делает недоступным использование полного таблицы ROWS UNION WITH EXECUTE STATEMENT IN AUTONOMOUS TRANSACTION EXIT FETCH CURSOR FOR EXECUTE STATEMENT ... DO FOR SELECT ... INTO ... DO Предложение AS CURSOR IN AUTONOMOUS TRANSACTION LEAVE OPEN CURSOR Разрешение

Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand the database: for person in Person.select(): print(person.name) # prints: # Bob # Grandma L. # Herb Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type == 'cat') for is a big problem with the previous query: because we are accessing pet.owner.name and we did not select this relation in our original query, peewee will have to perform an additional query to retrieve

Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand person in Person.select(): print(person.name, person.is_relative) # prints: # Bob True # Grandma L. True # Herb False Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type is a big problem with the previous query: because we are accessing pet.owner.name and we did not select this relation in our original query, peewee will have to perform an additional query to retrieve

Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand person in Person.select(): print(person.name, person.is_relative) # prints: # Bob True # Grandma L. True # Herb False Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type is a big problem with the previous query: because we are accessing pet.owner.name and we did not select this relation in our original query, peewee will have to perform an additional query to retrieve

Grandma’s record from the database. To get a single record from the database, use Select.get(): grandma = Person.select().where(Person.name == 'Grandma L.').get() We can also use the equivalent shorthand person in Person.select(): print(person.name, person.is_relative) # prints: # Bob True # Grandma L. True # Herb False Let’s list all the cats and their owner’s name: query = Pet.select().where(Pet.animal_type is a big problem with the previous query: because we are accessing pet.owner.name and we did not select this relation in our original query, peewee will have to perform an additional query to retrieve

are using psql, you can verify that the extensions are installed by running this query: ```sql SELECT name, default_version, installed_version FROM pg_available_extensions WHERE name LIKE 'postgis%' EXTENSION address_standardizer; The following test requires no rules, gaz, or lex tables ```sql SELECT num, street, city, state, zip FROM parse_address('1 Devonshire Place PH301, Boston, MA 02109'); these. 3. To confirm your install is working correctly, run this sql in your database: ```sql SELECT na.address, na.streetname, na.streettypeabbrev, na.zip FROM normalize_address('1 Devonshire

see postgis, postgis_topology as available extensions in PgAdmin -> extensions. psql ```sql SELECT name, default_version,installed_version FROM pg_available_extensions WHERE name LIKE 'postgis%' address_standardizer CREATE EXTENSION . SQL : CREATE EXTENSION address_standardizer; rules, gaz, lex ```sql SELECT num, street, city, state, zip FROM parse_address('1 Devonshire Place PH301, Boston, MA 02109'); postgis_tiger_geocoder UPDATE; tiger.loader_platform tiger.loader_variables . 3. SQL : ```sql SELECT na.address, na.streetname, na.streettypeabbrev, na.zip FROM normalize_address('1 Devonshire