SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
|
Alati teme | Način prikaza |
|
23. 09. 2009. | #1 |
Milan Cvejic
Wrote a book
|
Graph path problem...
Zdravo, elem citam joe celkovu knjigu i tu se pojavljuje jedan problem koji ne mogu da resim...
naime imam sledecu tabelu: Kôd:
step_1 | step_2 | step_3 | step_4 | step_5 | total_cost | path_length --------+--------+--------+--------+--------+------------+------------- s | s | s | x | y | 11 | 1 s | s | u | v | y | 11 | 2 s | s | u | x | y | 11 | 2 s | s | x | v | y | 11 | 2 s | s | x | x | y | 11 | 0 s | s | x | y | y | 11 | 2 s | u | u | v | y | 11 | 2 s | u | u | x | y | 11 | 2 s | u | v | v | y | 11 | 2 s | u | v | y | y | 11 | 4 s | u | x | v | y | 11 | 4 s | u | x | x | y | 11 | 2 s | u | x | y | y | 11 | 4 s | x | v | v | y | 11 | 2 s | x | v | y | y | 11 | 4 s | x | x | v | y | 11 | 2 s | x | x | x | y | 11 | 1 s | x | x | y | y | 11 | 2 s | x | y | y | y | 11 | 2 Kôd:
s x x v y = s x v v y = s x v y Hvala
__________________
http://weevify.com |
23. 09. 2009. | #2 |
Goran Pilipović
Sir Write-a-Lot
|
A po kom kriterijumu si tu redovi isti? Ja ne vidim da su isti (u 2:29 am)
__________________
Goran Pilipović a.k.a. Ugly Fingers Bradley f.k.a. bluesman I don't always know what I'm talking about but I know I'm right! |
23. 09. 2009. | #3 |
Milan Cvejic
Wrote a book
|
recimo ova dva:
Kôd:
s | u | u | v | y | 11 | 2 s | u | v | v | y | 11 | 2 Kôd:
s u v y
__________________
http://weevify.com |
23. 09. 2009. | #4 |
VD IT Direktora
Invented the damn thing
Datum učlanjenja: 08.06.2005
Lokacija: Beograd
Poruke: 2.118
Hvala: 503
1.307 "Hvala" u 282 poruka
|
Šta znače te kolone? Jel da ne može da bude više od 4 koraka u putanji? U kojoj ti je strukturi putanja?
|
23. 09. 2009. | #5 |
old school
Professional
|
Iskreno - nisam skontao pitanje ...
__________________
Blog: Baze podataka ------------------------ Oracle OCP DBA Oracle OCE SQL Expert Oracle OCP Developer Certified MySQL DBA |
23. 09. 2009. | #6 |
Goran Pilipović
Sir Write-a-Lot
|
Ja tek počinjem da razumem
Znači ti izbacuješ dupla slova i ostaju samo unique karakteri? Da li to znači i da je s u v y = s u y v = y v u s Ili mora da bude isti redosled ?
__________________
Goran Pilipović a.k.a. Ugly Fingers Bradley f.k.a. bluesman I don't always know what I'm talking about but I know I'm right! |
23. 09. 2009. | #7 | |
Webeloper
Professional
|
Citat:
suuuy = suy = suyyy
__________________
Before you criticize someone, walk a mile in their shoes. By the time they get angry you're a mile away and you've got their shoes! |
|
23. 09. 2009. | #8 |
VD IT Direktora
Invented the damn thing
Datum učlanjenja: 08.06.2005
Lokacija: Beograd
Poruke: 2.118
Hvala: 503
1.307 "Hvala" u 282 poruka
|
Drugim rečima, izbacivanje višestrukih karaktera iz stringa?
Postgres: Kôd:
test=# select regexp_replace('asssadddv', E'(.)\\1+', E'\\1', 'g'); regexp_replace ---------------- asadv (1 row) |
23. 09. 2009. | #9 |
Milan Cvejic
Wrote a book
|
@grocky, upravo to.
@jablan, SQL mi je potreban, ne regexp...
__________________
http://weevify.com |
23. 09. 2009. | #10 |
Ivan Dilber
Sir Write-a-Lot
|
jel moze da se doda nova kolona koja bi bila skup (tip SET), i sadrzavala cvorove ? Onda bi manje vise lako mogao da ih poredis, a i ne bi imao problem sa duplikatima
__________________
Leadership is the art of getting people to want to do what you know must be done. |
|
|
Slične teme | ||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
Double float problem - resen, ali ima dodatni problem :0 | ljtruba | (X)HTML, JavaScript, DHTML, XML, CSS | 34 | 23. 08. 2008. 02:28 |
Canvas 3D Graph | kodi | (X)HTML, JavaScript, DHTML, XML, CSS | 1 | 05. 08. 2007. 21:37 |
Da li je određeni path stvarna adresa fajla? | Ilija Studen | PHP | 4 | 09. 06. 2006. 17:07 |